
Re: Partial sum is not calculated
Celambarasan Adhimulam Oct 10, 2012 7:07 PM (in response to Nandor Santa)If there is a possibility of null values you can try with
RangeSum(Sum(field1),Sum(field2),Sum(field3))
Celambarasan

Re: Partial sum is not calculated
Nandor Santa Oct 11, 2012 8:38 AM (in response to Celambarasan Adhimulam )Dear Sir, thank you for your answer, I tried the formula but it is still not working. I am uploading the QV file I am working on, please observe the last two columns, they should show the same values. The first one is with the formula you proposed, the second one collects the data from the excell file, where I calculated the final value. Please collaps the rows in the pivot table, and the value becomes zero.
The project is about calculating the catering costs based on a unit price and the presence of the kids in the 5 working days of a week.
Thank you

Prezente v5 for QV Community.qvw 201.5 K

Re: Partial sum is not calculated
Celambarasan Adhimulam Oct 11, 2012 9:19 AM (in response to Nandor Santa)You expression should look like this
=RangeSum(Sum(Luni*PU_furnizor)
,Sum(Marti*PU_furnizor)
,Sum(Miercuri*PU_furnizor)
,Sum(Joi*PU_furnizor)
,Sum(Vineri*PU_furnizor))

Re: Partial sum is not calculated
Nandor Santa Oct 11, 2012 12:56 PM (in response to Celambarasan Adhimulam )Thank you, now it works.


