The MarginPct account will return the value of GrossMargin/TotalRevenues.
Table 110. Example of Pro_Rata_Ratio Function
Account | Jan2014 | Feb2014 | Mar2014 |
|---|---|---|---|
A#GrossMargin | 1000 | 100 | 750 |
A#TotalRevenues | 2000 | 400 | 1000 |
Pro_Rata_Ratio(“A#GrossMargin”,”#TotalRevenues”) | 0.50 | 0.25 | 0.75 |
The result returned from the PRO_RATA_RATIO function is as follows:
HS.EXP "A#MarginPct = A#GrossMargin / A# TotalRevenues”