Forum Discussion

OneStreamNewbie's avatar
OneStreamNewbie
New Contributor
4 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 GetDataCell function for division, it actually went back to use the value 0.75 to calculate the division. I tried using a dynamic calc with Math.ceiling function, not working. Please help.

Thank you.

Cube View
Dashboards

2 Replies

    • OneStreamNewbie's avatar
      OneStreamNewbie
      New Contributor
      2 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.