Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
i'm using a table to calculate some percentages of values with if formula's.
But it doesn't give me the right total value.
This is the formula of 'MESE+1': if(Mese_ricevimento='1', sum(Importo)*$(%_mese_corrente),'')
your expression gives you a line based result. but what should Qlik do in total?
rangesum(aggr(
if(Mese_ricevimento='1', sum(Importo)*$(%_mese_corrente),'')
,Mese_ricevimento))
Regards
In the blue box i would like to get the sum of the three values = 4300.
If i write:
if(Mese_ricevimento='1', sum(Importo)*$(%_mese_corrente),sum(Importo))
it doesn't give the right value
try below
rangesum(if(Mese_ricevimento='1', sum(Importo)*$(%_mese_corrente),null()))
May be this
Sum(Aggr(
If(Mese_ricevimento = 1, Sum(Importo) * $(%_mese_corrente))
, Mese_ricevimento))
Thanks,
but this doesn't work.
It gives 0 as total value instead of 4300