The account MarginPct will return the value of GrossMargin/TotalRevenues.
Table 23. Example of Pro_Rata_Ratio Function
Account | Jan2001 | Feb2001 | Mar2001 |
|---|
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”