This week’s Management Reporter tip for Microsoft Dynamics ERP, the third in our series, is on Ratios in Reports. In case you missed our first two tips, you can check them out on our blog here.

Ratios can sometimes be complicated and may seem like you need to export to Excel to do them.  Using other non-printing rows to calculate ratios and other formulas will eliminate the need to export to Excel.

Row Definition: Use the NP function to hide the data used for the ratios or formulas under print control.

MR 3 Ratio Row Definition

Result:

MR 3 Ratio Result

This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in more training, please contact us or visit our calendar to register for an event.

Be sure to subscribe to our blog so you don’t miss next week’s tip – @UNIT Restrictions.