Hi.
I need to compare a cuurent record to a record 2 records back. Obviously I can get 1 back by using the "previous" command but I don't know how to go further.
I tried to create a calculated field @previous1 and then take a previous of that field by creating @previous2 but it did not work.
Any suggestions would be greatly appreciated.
Thanks
I need to compare a cuurent record to a record 2 records back. Obviously I can get 1 back by using the "previous" command but I don't know how to go further.
I tried to create a calculated field @previous1 and then take a previous of that field by creating @previous2 but it did not work.
Any suggestions would be greatly appreciated.
Thanks