Forum Discussion
Solved
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...
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.
can you divide by same value?
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.