Hi ,
Here's my problem. I have an invoicing report where the overall summary for the whole report is let's say 200.1540 which comes out to 200.15, but when each detail line is broken down into it's respective grouping the group totals add up to 200.1570, which comes out to 200.16. I need the totals to match but i am not sure how to affect them either way the rounding on both fields are set to 0.01 and i tried to adjust the formula for the overall summary , but CR would not let me sum the group total fields. the error in formula explorer says "this field can not be summarized."
Has anyone seen this before, and is there an appropriate work around?
Thanks in Advance, All help is greatly appreciated.
CK