Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Rounding without Truncating in Financial Reporting Studio (FRS)

edited Aug 20, 2019 5:22PM in Planning 10 comments

Summary

How can we scale values without truncating them when running FR reports in Excel?

Content

We have multiple reports that are reported in millions with one decimal place. From a presentation standpoint this is fine, but when users run these reports in excel and attempt to calculate the displayed ratios using the scaled data they are slightly off (due to truncation vs. rounding). Is there any way to build an FR report that only displays one decimal but still contains the full value to support this desired functionality?

 

Thanks,

 

Brian

Version

August Release
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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