Monday, March 19, 2012

How to find Sum on the summary field

Hi,

I need to find the grand total of a feild in the report ,which is already a summary field. How do i find the grand total of that field. any help could be appreaciable.

For example

No of Days
3.456
4.678
2.874
1.568...

I need to find the Sum(No of days). But no of days is already a summary field

ThanksTry using the Insert menu and choose 'Grand Total'. It should automatically place it in the footer of the report.

Hope this helps!
Jules|||I tried it to do like that but as it is alreadya calculated and summary filed it is showing that field in insert summary options. Anyway thanks for your advice.
Thanks
Sudharsan|||I guess I am not totally understanding here...

What is the summary not showing you?

Jules|||Okay, I went back and re-read what you wrote.

You have a summary field that pulls information in and gives you a summary of each individual day, by the day, right?

If so, you are only summarizing here, not doing a grand total (which you know). Did you go to the Insert menu at the top of the screen and go down to 'Grand Total'? It is right above 'Summary' there.

Jules|||Hi
Here i am attching the report for your reference. I want the grand total on the Average # of buss days field. Could you Please suggest me what to do.|||It won't let me open the report - it says that it is an invalid version. What version do you have?

I have a different version on my computer at home (I'm at work) so I can try it there...

Jules|||That report was build on Crystal 11

No comments:

Post a Comment