I would like to create a new field, called in the example below "IK|LocationRule" that shows the value "Consignment" if the prevoius record is "Fly". Basically i want that IK|LocationRUle cannot be never Fly, if the starting location is "Consignment". Can be fly only if the starting location (26/05/2021) is different than "Consignment"
I set this rule:
IF(Location&Previous(Location)='FlyConsignment','Consignment',Location) as IK|LocationRule
The rule is working just for the first record (27/05/2021) but i would like to have also the other days as Consignment.