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
What was your answer?
Never mind - I found the answer
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156