Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Hope you can help.
The attached QVW has a user selection for Start date and End date, for this example:
please select 1/6/2014 to 1/7/2014 and push submit.
3 meters should display : AA, BB , CC
AA should display correctly
BB and CC are missing a start and an end read respectively and hence total production field is display nonsense output.
I want BB to display the next available Reading found on the 2/6/2014
I want CC to display the previously available Reading found on the 30/6/2014
The data file cannot be amended and I require a chart based solution to the issue.
your help is much appreciated .
Richard
Try using the firstsortedvalue function. See attached qvw
Try using the firstsortedvalue function. See attached qvw
Brilliant , thanks