Forum Discussion
Solved
Flag Period
Hello all, I have this kind of table below : Order date id first use date 11/01/2021 15:18 id1 11/01/2021 10:11 11/01/2021 10:11 id1 11/01/2021 10:11 12/01/2021 12:53 id1 ...
MF_BI Try:
Flag Column = TRUNC(DIVIDE(([first use date] - [Order date]) * 1.,30))+1
MF_BI Try:
Flag Column = TRUNC(DIVIDE(([first use date] - [Order date]) * 1.,30))+1Thank you Greg_Deckler
