I have a hour meter in a transaction group that records downtime to SQL, I’d like to have an additional column updated with a modified value of the hour meter - i.e. record the hour meter (duration) but then divide the hour meter value by 60 and multiply it by a tag value (line speed) to record waste for the line at the current speed to the new column.
Any ideas on how to achieve this?
I would make an expression item in the group that performs that calculation. Make the new expression item write to a new column in the database. The expression will be something like:{Path/To/Hour/Meter} / 60 * {Path/To/Line/Speed}