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

    IF Condition in Chart Properties

    Caroline Acosta

      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