Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) MR 2012 - Budget forec...

MR 2012 - Budget forecast calculation

(0) Share

Report

Posted on by Community Member Microsoft Employee

I setup a actual/budget column that has two columns for each month and the print conditions are working correctly. What is not working is the total budget left. I thought when you put conditional printing on a column it would carry through to a total. The actual is fine, but the remaining budget is adding in the first two month instead of just showing the amount for the remaining 10 months. I don't remember this being and issue before - does anyone have a suggestion for the calculation? They wanted a total for actual to date and a total remaining budget, so my formula is to add the columns for each.

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: MR 2012 - Budget forecast calculation

Actually this does not work - if the budget was zero, it puts in a negative budget number which is not correct. Still looking for ideas.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: MR 2012 - Budget forecast calculation

Never mind - I figured it out - I took the budget total and subtracted the actual total. Sometimes just writing it out clears it up for me.