Forum Discussion
GA2
3 years agoRegular Visitor
Help with the Offset function
Trying to figure out the correct way to create the following column (in red) using the offset function with respect to equip_id partitions. The column "stat code" is a calculated column, dont know if...
GA2
3 years agoRegular Visitor
Thank you! However the formula gave me the same error
"Column 'Stat Code' in table 'TA_EQUIP_STATUS_HISTORY' cannot be found or may not be used in this expression."
Which is why i was thinking it may have something to do with the column "stat code" being a calculated column. Can I use the offset function on a calculated column? If so, maybe i'm doing something else wrong.
Appreciate you taking the time.