Datalink - Deviation calculation Issue

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



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.