3 Replies Latest reply: Aug 5, 2014 2:47 PM by Srikanth P RSS

    Calculation Condition Limitation

    Bella Mae

      Morning all

       

      I am trying to use the calculation condition on a chart to ensure that the user selects a filter before information is displayed.  I usually use =if(len([Transaction_Date Month])>0 or len([Transaction_Date Year])>0, 1,0) type equations but this doesn't work when the user selects more than one option in a filter multibox.  I have tried GetCurrentSelections([Transaction_Date Month]) and concat({$}distinct [Transaction_Date Month] but neither of these work either.

       

      If anyone know of a formula i can use that will not switch on till something is selected but will also recognise more than one selection in a field I would much appreciate it.

       

      Bella