Forum Discussion

uvrao33's avatar
uvrao33
New Contributor II
3 days 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 II
19 hours ago

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

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
16 hours ago

if you are getting 0, then one of the following is true:
account 430000 and/or 630000 is 0 or no data for the given POV.

Next step is to use either the excel addin, create a cubeview, or write to the log the POV and cell values for 430000 and 630000