Subtotal is not addig all the rows when if clouse is prezent

[#1]

I used the following formula to calculate the data in a column. I have an if clouse and the Subtotal is skipping a number.

=if(Tip_activitate='Rata lunara', sum(Rest_de_plata),

RangeSum(Sum(Luni*PU_suplimentar_de_plata)

+Sum(Marti*PU_suplimentar_de_plata)

+Sum(Miercuri*PU_suplimentar_de_plata)

+Sum(Joi*PU_suplimentar_de_plata)

+Sum(Vineri*PU_suplimentar_de_plata)))

I am attaching the qv file, please see column "Total costs"

Another issue I don't understand, in column "Name" som records are missing in some rows.

Thank you,

[Gysbert_Wassenaar]

In a pivot table a values is not shown when there are more records with the same value. It's shows a - instead. Also there are no records where Prenume_copil has a value if Tip_activate is Rata lunara. Show there is no value to be displayed, because it doesn't exist in the data.

[#3]

Thank you, this solved the problem with the lack of information in the Name column.

It stiil remains the issue with the formula I used, the subtotal still doasent contain the value of Rest_de_plata

[Gysbert_Wassenaar · Accepted solution]

Maybe the expression you are looking for is this one:

=sum(if(Tip_activitate='Rata lunara', Rest_de_plata,

+Luni*PU_suplimentar_de_plata

+Marti*PU_suplimentar_de_plata

+Miercuri*PU_suplimentar_de_plata

+Joi*PU_suplimentar_de_plata

+Vineri*PU_suplimentar_de_plata))

[#5]

Thank you, this is it!