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

or

 

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

 

 

 

But it didn't work. 

 

Thank you!

Outcomes