Forum Discussion

OneStreamNewbie's avatar
OneStreamNewbie
New Contributor
5 days ago

Round up cell value to integer for calculation

Hi All, I am trying to get a decimal value rounded up to integer for calculation (Not for display). The current cube view cell value is 0.75. I can make it displayed as 1. but, when I put it in GetDa...
Cube View
Dashboards
pranav46's avatar
pranav46
Contributor III
5 days ago

can you divide by same value?

  • OneStreamNewbie's avatar
    OneStreamNewbie
    New Contributor
    3 days ago

    Updates: dynamic calc worked. It rounded the value to 1 now. The issue exists that when it is used in another row for calculation with getdatacell function: GetDataCell((Divide(CVR(DynamicCalcRoundedCell), CVR(Cell2)))*100), the dynamicCalcRoundedCell value went back to 0.75 for calculation, not the value of 1.