Skip to Content

webi sections displaying incorrect subtotal

Hi,

I initially applied a section on a Org code field and then I applied Sum on Amount which is resulting in a Grand total for each section instead of Sub total for each section.

FYI, Amount is the measure object with Aggregation SUM.

Please see the picture below, for the first section we should be getting sub-total of 1170 (600+570), etc.

I applied context functions, etc but for some reason I am unable to figure it out. Did anyone face this kind of issue before. If so, please help me figure it out.

FYI, I am using BO 4.1 SP 9.

Thanks & Regards.

Naveen.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 25, 2017 at 04:21 PM

    Make sure the formula in the footer cell showing the sum is correct. Try changing it to : =Sum([Amount])

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 26, 2017 at 11:18 AM

    Don't apply context in the sum. Just =Sum([Amount]) should be good enough.

    Add comment
    10|10000 characters needed characters exceeded