How to Calculate 3-Month Average Wage Cost - Management Reporter

(0) Share

Report

Posted on by PattiK323

297

I am trying to calculate the 3-month average wage cost for Jun-Aug. I started with 2022; but, once I get htis to work, I will be applying to the previous 3 years, as well.

However, when I generate the report using this column definition, All the prints is the header information. There is no data.

What am I doing wrong?

This is my Column Definition:

This is my Row Definition:

2313.Row.png

I have both the row and column definition specified in my Report Definition:

0211.Report.png

Thank you.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

JakeF Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Summing columns with a range, B:D for example, will only sum printing columns by design. If you want to sum columns regardless of if they are printing, they must be specifically referenced, B+C+D for example. Also remember to add parentheses for order of operations if you want all three of those columns to be divided by the number of periods (B+C+D)/PERIODS.

Was this reply helpful? Yes No
PattiK323 297 on at

Like (0)

Report
Copy link

Link copied!

Thank you. Making the changes, I now get numbers to calculate and print; but, they are not correct.

For example, Operating Personnel Wages (account 4500) are $100 for June, $200 for July, and $300 for August; but, the 3-month average is calculating as $75. It looks like it's dividing by 8 (the August period ?), instead of 3 months (June-July-August).

Was this reply helpful? Yes No
Verified answer

JakeF Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I edited the post to use generic numbers. The formula (B+C+D)/PERIODS will sum up those three columns and divide by the period number the report was generated for (8 in this case). If you want it to divide by 3 instead, change it to (B+C+D)/3.

Was this reply helpful? Yes No
PattiK323 297 on at

Like (0)

Report
Copy link

Link copied!

I did that and it works, other than some weird and missing data for 2019 and 2020, which I need to figure out. Thanks for your help!

Was this reply helpful? Yes No