1 Reply Latest reply: Jun 8, 2014 4:22 PM by Clever Anjos RSS

    If a sum with a set analysis does not equal zero

    Simon Brulotte

      Hi,

      I tried a straight table with this sum:

      sum({<%CLE_Code_Paie_Type_Dist={'834-G','834-D','340-D'}>}Montant)

       

      Works like a charm.

      Now I am trying to include this in  a dimension as follows:

      if ( Sum({<%CLE_Code_Paie_Type_Dist={'834-G','834-D','340-D'}>}Montant)<>0, Compagnie

       

      So I'm trying to show only companies that have had one of these three Pay codes.

      If their sum is 0, I do not want to show them...

       

      I get a calculation error in calculated dimension message.
      What am i doing wrong?