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.
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.