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

    IF Condition in Chart Properties

    Caroline Acosta



          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?