Share
Report
5Hi. I have a column layout to report quarterly with Rev/expense unit from tree in own column. I have a column to calc net rev of these separate units. I added a column that pulls the summary of all the units to arrive at net rev for a previous quarter or other period. The row def lists the sales emps.
The problem is with the column calculating net from prior period/qtr. The expenses are being added to revenue instead of deducted. There is not an option to specify rev vs expense type as there is in the row format. (same qtr used for previous qtr for proof)
How can I get this column to differentiate between rev vs expense and calc net correctly?
Categories:
All responses (
Answers (
