i want that if value of originalestimate is empty display presale estimate and if its not empty display original estimate iam using
if(OriginalEstimate != 'Empty'; OriginalEstimate;presaleestimate)
it gives me value of original estimate when its not empty but it is not giving me value of presale estimate when originalestimate is empty how can i do so
Hello @Sanjivani Wayal ,
This is due to how Structure's formula language considers the value of Original Estimate if it is not defined.
Please try this modification to your formula:
IF OriginalEstimate != undefined:
OriginalEstimate
ELSE:
PresalesEstimate
Let me know if it helps!
Best,
David
IF originalestimate :
(originalestimate)
Else :
(presaleestimate)
This worked for me
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.