AnsweredAssumed Answered

Issues in PI Expression

Question asked by Jcan on Apr 17, 2018
Latest reply on Apr 18, 2018 by Jcan

Hello all,

I've an expression for multi state in PIprocessbook,

My expression is comparing the average of TAG1 between the first day of the year and now with TAG2

so, i try there lines but nothing is good.

  • if TagAvg('TAG1', Concat('01-Jan',Year('*')), '*')> 'TAG2' then 1 else 0
  • if TagAvg('TAG1',  Concat("01/01/","2018")), '*')>  'TAG2' then 1 else 0


I have a some error popup "Point or expression evaluation error"



But it's running best if i wrote:

  • if TagAvg('TAG1', '01-Jan-2018', '*')> 'TAG2' then 1 else 0          (but it's not a good idea to write as like it.)
  • Concat("01/01/","2018") ====>>> 01/01/2018
  • Concat('01-Jan',Year('*'))====>>> 1/Jan-18


Some one have an idea?

I need your help please.