AirTable Gurus:
I’ve been struggling for a couple hours to apply @W_Vann_Hall’s solution from this post to a similar scenario. I wonder if anyone would be willing to take a quick look and see what I’m doing wrong in my rollup formula? Here’s a link to my example base .
As you may be able to see from what I’ve got, I’m trying to calculate the change between a patient’s Weight in one record with the Weight in the next record. Unfortunately, the records are not sequentially dated, so I couldn’t use the exact formula @W_Vann_Hall provided. Instead, I just auto-numbered the records, and tried to use the rollup field to provide the Weight from the “previous” record by just subtracting “1” from the Patient_Record field. Obviously, it’s not working, but I fear I’m out of my depth here and can’t seem to figure out why…
