Need help on calculation logic
Hi,
I am trying to implement a logic and it is not working. My issue is with below three rules and tsmin is giving 0 value. Any advise on this will help.
Below example lead time = 2,
Start = if(frozen > lead time, if(WD==1, lag(Dispatch tmp)+1,lag(Dispatch tmp)),0)
Dispatch=if(current==0,0,if(frozen > lead time && WD==1,tsmin(calculated index, start),lag(Dispatch tmp))
Dispatch tmp=Dispatch
| today | ||||||||||||||||
| Current | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| WD | F | F | T | T | F | F | T | T | F | T | T | F | F | T | T | F |
| frozen | 0 | 0 | 1 | 2 | 2 | 2 | 3 | 4 | 4 | 5 | 6 | 6 | 6 | 7 | 8 | 8 |
| Calculated Index | 999999 | 999999 | 7 | 8 | 999999 | 999999 | 11 | 12 | 999999 | 14 | 15 | 999999 | 999999 | 18 | 19 | 999999 |
| Start | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 8 | 8 | 9 | 12 | 12 | 12 | 13 | 15 | 15 |
| Dispatch | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 8 | 8 | 11 | 12 | 12 | 12 | 14 | 15 | |
| Dispatch tmp | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 8 | 8 | 11 | 12 | 12 | 12 | 14 | 15 | 0 |
Thanks,
Radhika
0