Create calculated column using OVER function

[Hector Gutierrez 2]

Hello,

I need help creating a calculated column that will calculate the difference between hour readings of a piece of equipment over a given date. Below is an example of what i need to accomplish. The "Hrs since previous" column is what i need to create.

[Gaia Paolini]

Use calculated column:

SN([Hrs] - Last([Hrs]) OVER (Intersect([Equipment],Previous([Date]))),100)

but first you need to correct the error in your last two dates (should be 2019 not 2018) otherwise the date order does not work.

SN(..) takes either the first argument, or if the first argument is null the second (100)