3 Replies Latest reply: Apr 19, 2017 4:30 AM by Deepak Sharma RSS

    Calculation condition. Multiple values.

    Carl Blunck

      Hi world,

       

      I need to apply a calculation condition on a chart so it will only display when no selection is made in 2 separate fields.

       

      The 2 fields are called:

       

      [Payment Type Category]

      [Time Category A]

       

      Tried the following if statement but it is failing:

      =if(GetSelectedCount([Time Category A])=0 or GetSelectedCount([Payment Type Category])=0,1,0)

       

      Solution?

       

      Cheers

      Carl