AnsweredAssumed Answered

Step through values in Dataset

Question asked by QWorth on Mar 27, 2017
Latest reply on Mar 27, 2017 by QWorth

Hi there,

 

I have a dataset that changes between zero and a non-zero value every couple of minutes. My ultimate goal is to list the last (say) ten non-zero values in a PB display. The list would update whenever there is a new non-zero value. The time between value changes is not predictable. My original strategy was to step through the latest values in the dataset and pick out the non-zero values to list. In my case the dataset might look like this (starting from the most resent value): 551, 0, 554, 500, 0, etc.  Is there a way to step through a dataset’s values as I've described with VBA?

Outcomes