Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

caluclating b(w) variances

Posted on by 55

I am brand new with FRX and am having trouble even figuring out where to get the answer to this question because I don't know the proper vocabulary..

I am trying to figure out if there is a way to calculate a variance to budget showing better(worse). So for revenue (credit accounts/lines) I would take actual minus budget and for expense accounts (debit accounts/lines) I would take budget minus actuals. My report compares actual month to budget, actual to prior year and the same columns for year to date. 

For the variance columns only I need the revenue, other income and net income lines to  be actual minus budget and all the expense lines and subtotals to be budget minus actual. It seems to me I need to do this in the Column set but it is only for certain rows and I am not sure how to accomplish that if it is even possible.

 

Thank you

*This post is locked for comments

  • BBibelhauser Profile Picture
    BBibelhauser 65 on at
    RE: caluclating b(w) variances

    What was your answer?

  • Verified answer
    Bev Profile Picture
    Bev 55 on at
    Re: caluclating b(w) variances

    Never mind - I found the answer

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans