Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I need to revise and need help on my conditional formula which I inherited ...
The original formula is
(concat(DISTINCT [KeyFig_Name2_XY], '|'), 'A + B')
And I need to revise that IF my field Status = Active, then KeyFig_Name (from different field) = A
So, I came up with this revise formula but it doesn't work:
=IF (Status = 'InActive',(concat(DISTINCT [KeyFig_Name2_XY], '|'), 'A + B'),(concat(DISTINCT [KeyFig_Name], '|'), 'A '))
Is there something wrong to this?
Thanks
Look i let you a simple example with dummy data, hope this helps!!
Regards!
Hi,
I am not sure whether I understand you correct.
I have replaced , by & in your expression. See the expression below.
IF (Status = 'InActive',(concat(DISTINCT [KeyFig_Name2_XY], '|') & 'A + B'),(concat(DISTINCT [KeyFig_Name], '|') & 'A '))
Im not the owner of the question, but yhea this one works!
Hi! Venu and Raul,
It didn't work ...Is it something to do with the other formula under Definition ?
Sum(If(KeyFig_NameZ= 'Demand',KeyFig_Amt))
Hi,
Could you please explain your problem clearly (if possible then attach your sample application). Why you need CONCAT in your earlier expression?
Instead of using IF condition, you can use SET expression as below:
SUM({<KeyFig_NameZ = {'Demand'}>} KeyFig_Amt)
Look i let you a simple example with dummy data, hope this helps!!
Regards!
Raul,
Your sample really helps a lot...I initially place my formula in the conditional box instead of the Definition box
Thank You..