Skip to main content
Manjunathak
Newcomer
Mar 13, 2024 5:09 PM UTC

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

    aricgresko
    aricgresko
    Veteran
    Mar 13, 2024 7:07 PM UTC

    Make sure you also have the Excel Number Format (Excel --> ExcelNumberFormat) setup in the Cell Format section of the Cube View. 

    aricgresko_0-1710356818857.png

    Best practice would be to have reporting parameters built and assigned to Cube Views for consistent formatting across all reporting. 

      MikeG
      MikeG
      Contributor
      Mar 13, 2024 8:30 PM UTC

      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,

      Terms & ConditionsAccessibility statement