Forum Discussion

uvrao33's avatar
uvrao33
New Contributor II
4 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
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
3 days ago

Change the line

api.Data.Calculate("A#520000 = A#430000 "*" & Var1 & ")

to 

api.Data.Calculate("A#520000 = A#430000 * " & Var1.ToString(System.Globalization.CultureInfo.InvariantCulture))

 

  • uvrao33's avatar
    uvrao33
    New Contributor II
    2 days 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
      22 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