AnsweredAssumed Answered

Datalink - PIArcVal Time Stamp

Question asked by Martin.Roy on Nov 23, 2016
Latest reply on Nov 28, 2016 by avanfosson

Hi,

I have an Excel with value from Tag1 with Time Stamp and I am using PIArcVal Previous and Next (with the time stamp) to see what was the value of the TagB during the time stamp of Tag1 (Don't want to use interpolated).

 

Datalink.jpg

I am able to add it to one row, but when I tried to change

=PIArcVal(Verification!$B$1;Verification!$A$8;1;"";"next") to remove the $ from $8 (to be able to applied this to all my rows)

I got the error "You cannot change part of an array"

 

PS : I dont want to change manualy all the date for every row.

Please help me.

Martin

Outcomes