I have a report where we are pulling P&L data. My Projected budgeted amount formula is pulling all appropriate columns of data, which is accurate when looking at the particular monthly columns and the budgeted column for the revenue/expense rows. However, when calculating a % calculation at the bottom of the P&L report, my Budget column formula sums the percentages for all months, which is not accurate. I think i can over-ride it to not calculate, but is there a way for me to recalculate that particular "cell" row and column ?
Here is the image of my Row Definition. Box in Black is my formula that works for all columns except my Projected projected column because that is a formula.
Here is an example (data is not real). My top columns are P&L and my budget column totals based on the formula are correct. The cell in yellow is a column formula summing A:C, and I need that calculate on the budgeted totals rather than summing the monthly %.
*This post is locked for comments
I have the same question (0)
