Custom Report - Ability to decide if a formula row or column takes precedent
You can add formula columns and rows to a report, but from what I can tell, the column formula always takes precedent over the row. It would be cool if you choose if you want the row formula to calculate in the column formula column
3
votes
Aaron Vaughan
shared this idea
-
Raymond Suen
commented
I agree with Debbie, this is very critical feature to our custom P&L report as the gross margin % is summing all years instead of applying the formula, which cause misleading to our P&L readers.
-
Debbie Forman
commented
I agree ... this report has a formula total column but the margin % is summing
all columns instead of applying the formula to the column itself
