Hi Guys,
I need to manipulate the following dataset with a set analysis in the front end or sort of calculation in the back end.
I have flags in fields for calculating movements. But now need to change the flags of the last counter date (=always the last Day of the Month,)
As you can see is that this movement of the last day of the Month should be manipulated to Counter Date+1 and that the current record actualty didn't happend...I should be placed
Orginal dataset:
Counter Date %OrderLineID _Cont_Move_NEG _Qty_Saldo_WEEK
04/06/2017 101368 - 1
11/06/2017 101368 - 1
18/06/2017 101368 - 1
25/06/2017 101368 - 1
30/06/2017 101368 -1 0
New / Output Dataset:
Counter Date %OrderLineID _Cont_Move_NEG _Qty_Saldo_WEEK
04/06/2017 101368 - 1
11/06/2017 101368 - 1
18/06/2017 101368 - 1
25/06/2017 101368 - 1
30/06/2017 101368 - 1
01/07/2017 101368 -1 0
--
I was thinking about inter record function (backend or a rangsum frontend)
Every advice is welcome!
Kind regards
Robbie