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