Forum Discussion

CrispinC's avatar
CrispinC
New Contributor II
3 years ago

Calculate variance percentages for different rows

Hi I'm struggling to add lines to show Gross Margin % ((Total income less product related costs)/Total income)*100), overhead as a percentage of total income etc. I've tried using Getdatacell ref...
Cube View
  • PeterFu's avatar
    PeterFu
    3 years ago

    Hi,

     

    Maybe it's better to create a Gross Margin account and set it up with DynamicCalc as Account Type. Then use a member formula to calculate the Gross Margin, 'Calculate the Percentage
    Return api.Data.GetDataCell("Divide(A#61000:O#Top,A#60999:O#Top) * 100") - This is from Golfstream application.

    If you use the Admin Tool to create the formula, you could easily include the formula to do the Drill-down on the accounts involved in the calculation. I would say that is a better way of doing it.

     

    Peter

     

     

PeterFu's avatar
PeterFu
Contributor II

Hi,

 

Maybe it's better to create a Gross Margin account and set it up with DynamicCalc as Account Type. Then use a member formula to calculate the Gross Margin, 'Calculate the Percentage
Return api.Data.GetDataCell("Divide(A#61000:O#Top,A#60999:O#Top) * 100") - This is from Golfstream application.

If you use the Admin Tool to create the formula, you could easily include the formula to do the Drill-down on the accounts involved in the calculation. I would say that is a better way of doing it.

 

Peter

 

 

CrispinC's avatar
CrispinC
New Contributor II
3 years ago

Thanks Peter