I have a database that tracks movement of set pieces on a Broadway-style show. In each cue, set pieces move at a certain speed to a target position. I would like to add a calculation field that determins the starting position of the set piece based on the target position from the last time we moved that set piece. Does anyone know how to do that? Thanks.