I have a report which has three column groups(parent-child) and five row groups (adjacent). Each row group is having child groups.

We have calculations running row wise. The last two main row group calculations are based on the numbers in the previous three row groups.

I have completed the report. When I first preview in bids, the percentage is showing correctly at the top level. When I expand the the row group which is responsible for the calculation, the percentage value changes,

When I export the report to Excel, the percentage showing up is a different one.

The calculation for the percentage are done through Report>Code.

Please throw some light on this issue.

Thanks,

Vishy

Do you mean to say you use custom code for percentage calculation?

In any case it will vary based on group level.

Can you put some sample data and explain the difference for us to understand?

Hi Vishy,

According to your description, you have created a toggle action and calculated percentage using custom code. When you expand the row group, it displays incorrect percentage values. And it also display incorrectly in Excel render., right?

As Visakn16 mentioned, the value returned by code is based on group level. In your scenario, if you can return percentage values using functions, it would be better to calculate values using functions instead of custom code. Also based on report design, we can decide whether to use ReportItems built-in collection to calculate percentage values.

Regarding the issue, please share sample data and report design for our analysis. If possible, please provide some screenshots about expand result and Excel render result.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu