Expression working even if colomn is empty

Anonymous — Thu, 13 Jun 2013 13:17:50 GMT

Hi,

I have this charts with an expression :

if (designation<>'COMMUNS',

Sum ( {$<sens={0} >} montant)- SUM ( {$<sens={1}>} montant)

,(Sum (TOTAL{$<sens={0}, designation={'COMMUNS'} >} montant)- SUM (TOTAL{$<sens={1}, designation={'COMMUNS'}>} montant))*'0,1')

As you can see in the excel file, I don't have any resultat in the yellow field.

when the colomn total is empty, the expression doesn't calculate 23 560 as I would like it to do...

It only works for the 1st colum... (A1)

Any idea ?

Cheers

Clement

topic Expression working even if colomn is empty in QlikView