Rounding of number for flow in cube view

[Manjunathak]

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?  

[aricgresko]

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. 

[MikeG]

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,