Hello all,
On the job issue.
I have a table like the attached in my database. I need in QV to provide a parameter for Temperature (i.e. vTemperature) and assign to an inputbox. When the user sets the temperature (it is a limit) I want to calculate:
1. The 1st day that Temperature was above this limit (i.e. for 20 degrees -> 8/1/2014)
2. Sum the feed up until that date
3. Show the exact temperature of the day.
It is a dataset with more that 15.000 batches, per month and also a copy per Site (14 Sites).
Many thanks!!!
