ulhasj

Datalink - Deviation calculation Issue

Discussion created by ulhasj on May 29, 2014
Latest reply on Jun 4, 2014 by Gregor

Hi,

 

I want to calculate a min & max deviation of a parameter but in that i want to consider only those values which are remained deviated for some amount of time.

 

Lets say i have parameter named 'abc' whose min value is 10 & max value is 30 . If the value of that parameter deviates frequently then i don't want to consider all those values. But if value is deviated & remains deviated for some time say for 30s then & then only i want consider those values for min & max deviation otherwise just ignore rest of the values.

 

In Excel using DataLink function "PIAdvCalExpDat()" i have calculated all  the deviated values but i'm not able to calculate values which are deviated for some time.

 

 

 

Thanks,

 

Tanuja

 

 

Outcomes