Summary Not correct

[Former Member]

Dear all expert,

I had a CR which the summary field is not correct. The report is developed base on a transactional tables. I created some formula to do some simple converting such as totext and tonumber. But when I try to summarized by count or sum for those fields, the summarized was incorrect.

I do some filtering and select the latest data using

Let say we manually count that the summary was 4000, but the summarized of that particular field is actually returning me 4250 or etc.

Kindly please advice.

[Former Member · Accepted solution]

Sounds like you have either some group filters or conditional suppression. Both hide data but do not stop data being counted/summarised.

or Group Filters go to

Report -> Selection Formulas -> Grou

for conditional suppression look at all sections in section expert and see if any for suppression formula.

To over come you will need to use a Running total with a reverse condition to the suppression rules so that the suppressed records are not included.

Ian