topic Re: IF Condition in Chart Properties in Water Cooler

IF Condition in Chart Properties

Anonymous — Fri, 25 Oct 2013 17:30:13 GMT

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

Fri, 25 Oct 2013 17:40:38 GMT

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

Fri, 25 Oct 2013 17:46:18 GMT

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

Anonymous — Fri, 25 Oct 2013 18:17:22 GMT

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

Fri, 25 Oct 2013 18:22:00 GMT

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)

Fri, 25 Oct 2013 18:22:22 GMT

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

Regards!

Anonymous — Fri, 25 Oct 2013 20:33:53 GMT

Raul,

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

Thank You..