Wrong total in Calculation List report

[Chamopak]

Hi,

I created a list report that with a filter that only takes a portion of the data.
But when I add the total report, it will not add the correct total. The numbers are much higher that its suppose to
See attachment.


Yellow is what it is suppose to be (total) and blue is what its calculating (WAY OFF).

Thank you in advance for your help.

[MFGF]

Hi,

I created a list report that with a filter that only takes a portion of the data.
But when I add the total report, it will not add the correct total. The numbers are much higher that its suppose to
See attachment.


Yellow is what it is suppose to be (total) and blue is what its calculating (WAY OFF).

Thank you in advance for your help.

Hi,

Are you using a relational package or a dimensional package?
How is the total defined at the moment? Is it an automatic summary or is it a calculated value in the report (and if so, how is it being calculated)?
How is the filter defined?

Cheers!

MF.