Hi to all,
i have a Key figs, which calculate which calucated day wise quantity (fore cast(Day), Actual(day) .
Based on above Keyfigs , i have forecast(Cumulative) and Actual(Cumulative).
what is the Problem is.
Forecast (day & cumulate) has to be calculated from begining of the month to the end of the month.
Actual(Day & Cumulate) has to be calculated from begining of the month to the Present running day.
when i am finding the Actual(Cumulative) based on the Actula(Day) keyfig, it is cumulating correctly up to runing day but after present runing day( System date), it giving default value for remaining days as last cumulated value.
i should not get Actual(cumulate) after Present runing day.
because i has to calculte Gap(Cumulate) = Actual(cumulate) - Forecast(Cumulate).
What is the solution for this?