AnsweredAssumed Answered

Divide Two Columns in Select Statement Using Table Lookup / Asset Framework

Question asked by Salam91 on Jul 31, 2020

Hello every one,


I have a table in the library in PI Asset Framework,  I am creating an element template, adding an attribute template where I want to divide two columns of the table. 

Can anyone help with the syntax of the select statement? 


I tried:

SELECT ([IMN_TOTAL_OC]/[OP_HOURS])FROM [Indicatores] WHERE CENTER = '%..\ElementDescription%' AND GROUP = '%Element%';TC=TIMESTAMP



SELECT ([IMN_TOTAL_OC])/([OP_HOURS])FROM [Indicatores] WHERE CENTER = '%..\ElementDescription%' AND GROUP = '%Element%';TC=TIMESTAMP




But it didn't work. 


Thank you!