The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Rounding in cube views
Hi there,
We need to see cube view figures which are rounded to an integer. Could you please advise how to round figures in cube view?
This is a functionality that a lot of organizations are looking for, as the reconciliation process of rounding numbers in related tables in external reports takes up a lot of manual resources or complex coding. I've seen a solution some years ago in a competing product, that could do the calculations and stored it as a separate layer in a UD. As I understand, it's algebra math and settling where to put the rounding discrepancies so it sill makes sense.
I think it would be a great business opportunity for the consulting community.
JoakimK
OneStream Employee
OneStream EmployeeIn the formatting of the row/column, you can change the number format to N0, then it will display the data as whole numbers without decimals, and rounded to the nearest number.
I hope that helps.
Regards, Joakim