Forum Discussion

uvrao33's avatar
uvrao33
New Contributor III
4 months ago

How to get two decimal places in Member formula

Hi Everyone, I'm trying to write member formula (not dynamic calc), below is the syntax Dim Var1 as Decimal = Math.Round(api.Data.GetDataCell("A#630000").CellAmount, 2) api.Data.Calculate("A#52...
Application Properties
Consolidation
Cubes
uvrao33's avatar
uvrao33
New Contributor III
4 months ago

Hi, the result is zero after using above script, I checked pov is correct and all source accounts have data.

rhankey's avatar
rhankey
Contributor III
4 months ago

Well, then it is time to dump out the second data buffer to error log to see why you are getting zero.  You could be encountering a constraint issue.  Also dump out the value of Var1, as perhaps it is zero a NoData cell.