Unanswered

Insert new conditions in the beginning or middle of a calculated field

(0) Share

Report

Posted on by Manresa

Hi all,

I have a calculated field with close to 10 if-else conditions. I need to update this calculated field to consider a new condition that has priority over all the other conditions, so I need to place it in the first IF.

I don't see how I can insert a new condition. All I see is that I can delete existing conditions and append new ones to the end.

If I want to add a new condition to the beginning, do I need to remove all conditions and add them again, wasting a lot of time for something apparently trivial or there is something I am missing?

I tried editing the definition file of the calculated formula when you export the solution as unmanaged, but it is a way too complex XML.

Thanks,

David

Categories:

Microsoft Dataverse

All responses (2)

Answers (0)

Manresa 6 on at

Like (0)

Report

Re: Insert new conditions in the beginning or middle of a calculated field

Hi @parvezghumra,
Thank you for replying. I understand that and I try to avoid using Calculated Fields as much as possible now, but this one already exists and is being used in multiple places, so it is not very viable for us to substitute it everywhere now.
Parvez Ghumra 1,579 Super User 2025 Season 1 on at

Like (0)

Report

Re: Insert new conditions in the beginning or middle of a calculated field

@Manresa In my opinion, this is where the low-code approach creates maintenance difficulties. If you have the necessary skills within the team, it might be worth considering replacing your Calculated Field with some simple code instead depending on your use case (eg. plugin)