Skip to main content
M
Manjunathak
March 13, 2024

Rounding of number for flow in cube view

  • March 13, 2024
  • 2 replies
  • 0 views

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

    A
    aricgresko
    March 13, 2024

    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. 

    M
    MikeG
    March 13, 2024

    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