Total value in table

[Carlaf_93]

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),'')

[martinpohl]

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

[Carlaf_93]

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

[Kushal_Chawda]

try below

 rangesum(if(Mese_ricevimento='1', sum(Importo)*$(%_mese_corrente),null()))

[sunny_talwar]

May be this

Sum(Aggr(
  If(Mese_ricevimento = 1, Sum(Importo) * $(%_mese_corrente))
, Mese_ricevimento))

[Carlaf_93]

Thanks, 

but this doesn't work.

It gives 0 as total value instead of  4300