You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Adjust formula to sum scaled amounts correctly in Management reports

Received Response
52
Views
5
Comments

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!