If a sum with a set analysis does not equal zero

sibrulotte — Sun, 08 Jun 2014 20:14:51 GMT

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?

Re: If a sum with a set analysis does not equal zero

Clever_Anjos — Sun, 08 Jun 2014 20:22:46 GMT

you should "aggr"

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