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.