6 Replies Latest reply: Oct 25, 2013 4:33 PM by Caroline Acosta

# IF Condition in Chart Properties

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

• ###### Re: IF Condition in Chart Properties

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

• ###### Re: IF Condition in Chart Properties

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

• ###### Re: IF Condition in Chart Properties

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

• ###### Re: IF Condition in Chart Properties

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)

• ###### Re: Re: IF Condition in Chart Properties

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

Regards!

• ###### Re: Re: IF Condition in Chart Properties

Raul,

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

Thank You..