Time and version variance report


I used to be able to do a time variance report with columns like Actual Period, PY Acutal, Act Period - PY Act, R3m Actual, Budget Period, PY Budget, Budget - Act, etc and rows individually formatted with styling, number formats etc. They way I did this was with line item subsets from two modules, one with variance calculations collecting the numbers from a base module and then a final step to be able to format each row. In this last module I used two line item subsets in the collect statement.  Now, it is not possible to have two line item subsets in the same module anymore, but I still want to be able to do my nicely formatted reports. Any ideas, best practices on how to achieve this without using two line item subsets? Thanks! David Hagetoft Bconnected


Best Answer