WIP: Key Ratio reports

The Key Ratio reports use the global variable M3A_FKRReport3 as input for the report ID. Default value is M3FKR3. The measure used in Key Ratio reports is sourced from the Finance Key Ratio fact. It is analyzed by Accounting Period Date and uses the Sum aggregation.

Return on Working Capital by Period

Description: This report shows the fiscal period trend of the recorded amounts for report lines Working Capital (CA less CL) and PBT+Fin Revenue / Working Capital (%). The amount is plotted on the primary axis and percent on the secondary.

Measure: Recorded Amt

Chart type: 2 data series line chart, 1 line chart on Y axis 1 and 1 line chart on Y axis 2

Return on Total Capital by Period

Description: This report shows the fiscal period trend of the recorded amounts for report lines Total Assets Equity, and PBT+Financial Revenue / Total Assets (%). The amount is plotted on the primary axis and percent on the secondary.

Measure: Recorded Amt

Chart type: 2 data series line chart, 1 line chart on Y axis 1 and 1 line chart on Y axis 2

Return on Equity by Period

Description: This report shows the fiscal period trend of the recorded amounts for report lines Earnings after Interest before Tax, Adjusted Equity, and Profit before Tax/Adjusted Equity(%). The amounts are plotted on the primary axis and percent on the secondary.

Measure: Recorded Amt

Chart type: 3 data series combo, 2 grouped column chart on Y axis 1 and 1 line chart on Y axis 2

Adjusted Sales per Employee ('000's) by Period

Description: This report shows the fiscal period trend of the recorded amount for report lines Adjusted Sales and Adjusted Sales per Employee ('000's). The amount is plotted on the primary axis and quota on the secondary. The recorded amount for report line Employee is displayed in the tooltip.

Measure: Recorded Amt

Chart type: 2 data series combo, 1 column chart on Y axis 1 and 1 line chart on Y axis 2