Adjust formula to sum scaled amounts correctly in Management reports
Summary: How can I adjust the formula in Management Reports to sum only the scaled amounts instead of the absolute amounts, ensuring accurate data presentation without scaling issues?
Content (please ensure you mask any confidential information):
For example, in the screenshot below, all reports are formatted in thousands. When summing these amounts (5006 + 3458 + 323), the correct total should be 8787, not 8788. However, the current formula is summing the absolute amounts, leading to an incorrect presentation of data. This is a basic functionality expected by the client, as the system should not have casting or scaling issues in any reports. Which function can I use to address this issue?