Year-End Forecast analysis

[wossenhh]

Hello QV guru’s,

Can you please help me out how to write the expression for Year-end Forecast that shows the selected month + forward. For e.g. since I am using a fiscal year from April to March, when a user select Dec, the calculation amount should be from Dec 2016 till March 2017.

So the calculation for YTD Forecast will be :

Sum(History_Shipment * Price_Price) + Sum(Forecast_Adjusted Forecast * Price) for the current month forward in time.

Thanks

Wossen

[wossenhh]

Any help on this please?