03-13-2024 01:09 PM
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?
03-13-2024 03:07 PM
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.
03-13-2024 04:30 PM
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,