Look up for future periods
What's the formula for looking up only future periods?
In our module Professional Services Forecasting, I have actuals up to and including current period and blue inputs for forecast / future periods.
We then have a module that groups various job codes called Professional Services Profitability. This already splits out actuals into different categories. When I add in the forecasting lines, it then double counts the actuals.
So, how do I pull the information from Professional Services Forecasting into Professional Services Profitability for future periods only?
As you can see from the screenshot, Jan - July are duplicates of the total cross charge. It's only the August only values that I want to pull through. Please note, I've not updated the "Total Cross Charge £" sub total yet.
Hope this makes sense!