Hello,
The title is not very clearan example will be more at least I hope 😉
I encounter a problem for a column calculation Ending month forecast. I have 2 quantities my actual quantities and my forecast quantity I would like to know when (find a date or a number of months) where the sum of these 2 quantities will be equal To Qty to collect.
The Date used for the Forecast quantities (Planned Quantity) = Date_Plan.
The Date used for the actual quantities is Date.
Thank you in advance,
![2017-04-28+11_45_45-QlikView+x64+-+[C__Users_epetrini_Desktop_Cust+Part+Price+Amort+TMA.qvw].png](/legacyfs/online/161984_2017-04-28+11_45_45-QlikView+x64+-+[C__Users_epetrini_Desktop_Cust+Part+Price+Amort+TMA.qvw].png)