report break out by code which is added in query but not in the report layout

[marzbuzz]

Gurus,

I have a report that I need add logic to break it down more to the code level for some calculations. Code is added to the query of the report, but it's not in the report layout. However, the report is still break down to the code level.

Right now I'm seeing:

ID,    gross wages,  retirement,  benefits,  totals   
1          1500           0                0             1500
1          0                20              0              20
1          0               0                 100          100

I want to show below instead:

ID,    gross wages,  retirement,  benefits,  totals
1          1500           20                100             1620

Please let me know what may have caused the issue.

Thanks,
MB

[MFGF]

Gurus,

I have a report that I need add logic to break it down more to the code level for some calculations. Code is added to the query of the report, but it's not in the report layout. However, the report is still break down to the code level.

Right now I'm seeing:

ID,    gross wages,  retirement,  benefits,  totals   
1          1500           0                0             1500
1          0                20              0              20
1          0               0                 100          100

I want to show below instead:

ID,    gross wages,  retirement,  benefits,  totals
1          1500           20                100             1620

Please let me know what may have caused the issue.

Thanks,
MB

Hi,

Have you tried changing the calculations to be maximum([gross wages calc] for [ID])

and the same for the others?

Cheers!

MF.

[Invisi]

Max? It looks like total to me (see last column). It sounds like you have one or more aggregate options wrong, causing the report to show the individual rows instead of the aggregations. You may have set this wrong already in the framework for the various columns as their default rollup behaviour. How are the numbers set in the framework? As facts? And which aggregate options have you set for the measure data items in the report query?

[marzbuzz]

Thank you both.

Invisi,
I checked all the calculations in both report and FM and they are all facts and the regular aggregate are 'Sum' in FM and the aggregate function are 'Total' in report studio.

I was able to get around the problem by modify and add calculations for the new code in the FM and without using the code in the report query but still wonder what may have caused the issue.

Thanks,
MB