YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

Exclude Bad Data in PI-AddIn for Excel Options · View
Previous Topic · Next Topic
mcwherdl54
#1 Posted : Thursday, October 20, 2011 9:02:04 PM
Rank: Newbie
Groups: Member

Joined: 10/20/2011
Posts: 1
Location: Port Arthur, TX
How do I exclude any bad data using the 'calculated data' or 'advanced calculated data' calls in Excel?
Back to top
 Report Abusive | Report SPAM
Sponsor  
 

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.
Back to top  
squatty
#2 Posted : Friday, October 21, 2011 12:53:17 PM
Rank: Advanced Member

Groups: Member

Joined: 4/7/2011
Posts: 137
Location: KZN, South Africa
Hi and welcome to the forum.

You ahve to be more specific as what you clasify as bad data. In some cases values that show negative can be clasified as bad data, and in other cases it could be an actual state like "Calc Failed", "Bad"....

Keep in mind that when you do a calculated data of a float point, string or states will be excluded from the calculation. You can't add 10 and "Bad".

You can use the filter expression option in calculated data to "filter your data:

('TAGNAME')>0
('TAGNAME')<>"Bad"
('TAGNAME')<>"Bad" and ('TAGNAME')<>"Failed"

It all depends on your clasification of "bad" data.
Back to top
 Report Abusive | Report SPAM
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFVision Theme by Jaben Cargman (Tiny Gecko)
Powered by YAF | YAF © 2003-2008, Yet Another Forum.NET