I created a report that starts with Budget Net Income, shows variances +/- for a given period that tie to Actual Net Income at the bottom of the report.
Everything works, except for the top line and bottom lines, including the Better/(Worse) than Budget.
I'm getting $0 for BUDGET Net Income.
The result for ACTUAL Net Income is the variance that should be on the Better/(Worse) than Budget line (Actual minus Budget).
The Better/(Worse) than Budget line is showing $0.
I think this is due, at least in part, to the fact that my Column Definition is set up to be a calculation of Budget minus Actual for all other rows: i.e., the variance.
But, for the top and bottom line, I just want the amount, not a variance to anything. I.e., what is the Budget Net Income and Actual Net Income for each period?
I don't know how to correct this.
I tried using Row Modifiers (which I've never done before)-but, apparently, I'm not doing it correctly. Or, this is not the way to handle this situation.
Can someone please help?
Thank you.
P.S. The report is actually by month, with summaries by quarter, and a full year total. I'm just showing the first month in my screenshots, as if I can get that right, the others should follow.
