AnsweredAssumed Answered

DataLink offers the redundant results

Question asked by Dr.Zhou on Mar 11, 2019
Latest reply on Mar 11, 2019 by Dr.Zhou

Hello,

 

For the first time my DataLink offers me the redundant results, when I am in an effort to sum up start-up / shut-down regarding certain pump, as enclosed.

 

TIM图片20190311093850.png

The formula employed is, as of the first two columns.

=PICompFilDat("MyPump","18/11/1","19/3/11","('MyPump')=1 and prevval('MyPump')=0",0,9,"pi.trie.com.cn","outside")

 

Could you please help me out. Thanks in advance!

Best Regards

ZYY

2019.3.11

Outcomes