Skip to Content
Jul 19, 2018 at 11:42 AM

How to resolved issue with totals after using ForceMerge() function in report?


Hi All,

We have already developed webi report (Profit center wise couple of measures)

User came with new requirement, he want same report but region wise.

He gave us one excel file with Profit center and region mapping.

We added that excel file to report as new query.

Merged existing profit center object with the object from excel file.

And replaced Profit center object with Region object in report.

all measure start showing same value for every record.

so we used ForceMegre() function for all measures in Webi report to get the correct data.

Now data is coming right but the Total values of all the measures are not coming correct.

How to resolve this issue?

Thanks in Advance