on 02-04-2013 1:33 PM
How do I find the MAX value in a row of values?
So far my report looks like this:
0100 0300 0500 0700
pH 7.2 7.3 7.7 7.2
temp 11 9 9 12
I need my data to look like this:
0100 0300 0500 0700 MAX
pH 7.2 7.3 7.7 7.2 7.7
temp 11 9 9 12 12
I've tried using MAX(in[0100], [0300], [0500], [0700])), but that doesn't work.
Thanks!
-Eric
Hi Eric,
Create a formula with this code:
Local numbervar array arr;
arr := [{0100}, {0300}, {0500}, {0700}];
Maximum(arr);
Hope this helps!
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That's strange. Could you go to File > Options > Reporting tab > check "Convert Database NULL values to default" and also "Convert other NULL values to default".
Then go to File > Report Options > check the above options in here as well.
Let me know the results. If that doesn't work, please attach a copy of the report with saved data.
To attach the report, please make sure you change its extension to .txt first.
-Abhilash
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.