Group summary is acting up

[haneen97]

Hi,
I have a group summary that shows some weird numbers. For example the summary should be adding 1+2 = 3, it is showing 3200. Also, the same group summary is working fine the next page, I mean it adds correctly in one group but shows weird numbers in another. Can you please suggest areas where I can troubleshoot?

Thanks


Mo

 

[lbass]

Do you have any suppressed records? What is the summary you are using? Is it an inserted summary? A running total? Does it use a variable? Please provide more information.

-LB

 

[haneen97]

Yes, I am suppressing some records. I am using the sum summary. The summary is not using a variable. I inserted the standard summary fields on all the groups.

Mo

 

[haneen97]

HI,
I am all set. I made separate running total fields and it worked.

Thanks

Mo

 

[WarrenRoss]

Hi Mo.

Just out of interest, when you were experiencing problems with the summary field, did you have any group selection formulas or top/bottom N stuff in your report?