January 2012

Jan.

11

2012

Just Released—Creating Reports in Management Reporter II

by Jan Harrigan CPA

I’ve just finished writing Creating Reports in Management Reporter II—Step by Step Instructions on a Dozen More Reports. It’s a followup to the first in the series and covers 12 more reports and at least 20 tips, tricks & techniques.

Cheers—I’m celebrating! Jan

{ 0 comments }

Jan.

9

2012

How to Calculate an Average in Management Reporter

by Jan Harrigan CPA

Management Reporter makes it easy to calculate a period average.

Hey I haven’t posted in a while because I’ve been really busy writing my next training guide, Creating Reports in Management Reporter II—Step by Step Instructions on a Dozen More Reports (due out later this week). This post is one of the 20 items from Chapter 15—Top 20 Tips Tricks & Techniques. Here’s a preview of one of the new features I really love.

Use the new Periods function to calculate an average in the column definition

media_1325780816847.png
  1. Use the new ‘Periods’ to divide by the number of periods to calculate an average.
  2. This column must have something in the Period cell so that ‘Periods’ will know what number to use. I’m using Base here to tell MR to use the Report Definition period.

This new functionality makes calculating averages so much easier than in FRx.

Results

media_1326122519515.png

The above column gives these results. Simple.

BTW, this technique works exceptionally well on a Trend column (January through December—exactly like the one in Chapter 2).

Cheers—Jan

{ 3 comments }