Trying to create a report using an account hierarchy, with "allow expansion" function turned on, and calculating a percent change for each account level. Using the "variance percent" formula, the calculation works at the lowest level of the account hierarchy, but does not work at the subtotal and total levels. Does anyone have a tip or trick for this??
Example below: see percents calculate and display for salaries line (lowest level of account hierarchy), but not display for the Total Payroll line.
