Hi all.
I'm currently building a report to have each line of business numbers with after reallocating overhead costs.
Since we want to keep the transactions in Admin department as it is on GP, thought building a MR report would be the best way to do so.
Everything seems to be working so far, except for the fact that I cannot put multiple formulas on the same column - I can use one percentage (ex. 10%) but is there a way to use multiple percentages as below?
I was hoping I could have the actual numbers on one column and calculate the portion responsible to each LOB using different percentages (these percentages will change every month).
Or is there any suggestion on how to build cost reallocation report on MR?
Your help would be greatly appreciated!!