I need a calculation based from my excel formula

[altair]

Hi Guys can you help me with a calculation base on my excel formula. I need to get the difference between the data that i input yesterday from the data today. Sample of my excel file. [Date] [RCBC] [cDifference]

Thanks

[mr_vodka]

You can look into the GetNthRecord () function (with -1) but that will be based on the fact that you will always want the previous record even if you have gaps in the date.

If you want it to be precisely the day before, then you can create a calc that is YourDate -1. Then you can have a relationship keyed on this calc and your date.