Using Pi DataLink in excel to get values from a server.
The "TimeDat" function gets values for the time specified, in my case the time is in range Sheet1!$B$2:$B$26.
"I385.OL.MTR-71.FLOW" is the data tag for which I am polling.
Example of time in the range:
16-Sep-22 07:00:00
16-Sep-22 08:00:00
16-Sep-22 09:00:00
16-Sep-22 10:00:00
16-Sep-22 11:00:00
16-Sep-22 12:00:00
If the specified time has not come yet, I am getting a "No Data" in the cell, or a zero for when the value is actually a zero.
I want to suppress both the "No Data", and the "0" values.
I have tried IF statements and the only result I can get is "Index was outside the bounds of the array"
Anyone have any ideas on how to correct this?
Thanks!
The "TimeDat" function gets values for the time specified, in my case the time is in range Sheet1!$B$2:$B$26.
"I385.OL.MTR-71.FLOW" is the data tag for which I am polling.
Example of time in the range:
16-Sep-22 07:00:00
16-Sep-22 08:00:00
16-Sep-22 09:00:00
16-Sep-22 10:00:00
16-Sep-22 11:00:00
16-Sep-22 12:00:00
Excel Formula:
=PITimeDat("I385.OL.MTR-71.FLOW",Sheet1!$B$2:$B$26,"","interpolated")
If the specified time has not come yet, I am getting a "No Data" in the cell, or a zero for when the value is actually a zero.
I want to suppress both the "No Data", and the "0" values.
I have tried IF statements and the only result I can get is "Index was outside the bounds of the array"
Anyone have any ideas on how to correct this?
Thanks!