on 07-30-2013 8:58 AM
Hi All,
I have a report having summary on formula field in report footer.But i am not getting the result(result should be 30727).
Please find the report.
In report if we suppress the page footer section(there is a text box with red fonts) then i am getting the correct result.
I did every thing but unable to find the problem.
Please help
Hi Divya,
The section with the Text Box in Red color is on the Page Header and not the footer.
Suppressing or un-suppressing the section does not change the Grand Total for me; it always shows: 30760.350
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Very strange!
Try creating another formula with this code and place it beside the @total_amount formula on the GF3a:
EvaluateAfter({@total_amount});
numbervar g;
g := g + {@total_amount}
And, then create another to display the Grand Total just like the @grand_total formula.
Does this formula show the right results? But honestly, I'm not too sure why the report on your machine shows incorrect results when the same report shows right on my machine (I'm using CR 2011 SP02)
-Abhilash
Hi Abhialsh,
I created the formulas(blue color) as you suggested but still i am not getting the result.
Now please find the report here i suppressed the page header .so it is showing correct result.
If i show the page header again 30760 is coming.
My cr version is cr 2011 14.0.2.364 RTM
Please help
In this new report I get 30760 whether the section is suppressed or unsuppressed.
Is 30760 not correct? Have you tried manually adding the Sub-Totals and find out whether 30760 is right result?
P.S: The figure 30760 arrives after you subtract two other formulas from the Grand Total.
If you're saying 30760 is wrong result
a) what is the right Grand Total figure without the subtraction
b) what should be the right figure after the subtraction?
-Abhilash
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.