|
|
Rank: Newbie
Groups: Member
Joined: 5/24/2011
Posts: 1
Location: Australia
|
Hi,
I am trying to performe a percentage conformance calculation within excel. Basilly the percentage of time various tags a within a range of the target value.
I am trying to use the Timegt expression but I need to use absolute times and not relative time. I keep getting a syntax error when i try or occasionally a calc failed error.
it works with this expression:
timegt('21-wf-0607.pv','*-8h','*',0)
but not this. I tried using concatenate to get the formula together since it was referencing cells
timegt('21-wf-0607.pv',40686,40687,0)
Thanks for the help.
|
|
|
|
|
OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System. We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ or contact OSIsoft vCampus for more details.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
|
Hello, When you say the latter formula doesn't work, do you get "Calc Failed"? What if you try Code:
timegt('21-wf-0607.pv',"01-Jan-11","02-Jan-11",0)
? Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Member
Groups: Member
Joined: 6/9/2011
Posts: 12
Location: Brisbane
|
Thanks for the response. I got it to work pretty quickly using something like this
Timelt('21-WF-0607.PV','*-0.116474421301973d','*-0d',0)
|
|
|
|
Guest
|
