IF Condition in Chart Properties

[Anonymous]

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

[#2]

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 '))

[#3]

Im not the owner of the question, but yhea this one works!

[Anonymous]

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))

[#5]

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)

[#6 · Accepted solution]

Look i let you a simple example with dummy data, hope this helps!!

Regards!

[Anonymous]

Raul,

Your sample really helps a lot...I initially place my formula in the conditional box   instead  of the Definition box

Thank You..