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
Rounding of number for flow in cube view
i am pulling flow to cube view i want to round the number to two digit precision. i tied with number formatting N2 it didn't work. i can see the two digit in CV but real number still exist when i export to excel. How can i round the number?
2 Replies
Make sure you also have the Excel Number Format (Excel --> ExcelNumberFormat) setup in the Cell Format section of the Cube View.
Best practice would be to have reporting parameters built and assigned to Cube Views for consistent formatting across all reporting.
Hi Manjunathak check out this code here. ChristianW is a wizard, I've used this code and it works.
https://community.onestreamsoftware.com/t5/Rules/Rounding-the-result-of-a-formula/m-p/2145
Regards,
