Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ID | NUM1 | NUM2 | NUM3 |
1 | 4 | 4 (between 4 and null=4) | |
2 | 3 | 3 (between 3 and null=3) | |
3 | 3 | 5 | 5 (between 3 and 5 ,max=5) |
4 | 7 | 6 | 7(between 7 and 6 ,max=7) |
5 |
7 | 7 (between 7 and null=7) | |
6 | (between null and null =null |
HELLO
please see the table
i want an expression (edit script window) for NUM3
result
id | num3 |
1 | 4 |
2 | 3 |
3 | 5 |
4 | 7 |
5 | 7 |
6 |
thx
you can try using "nummax" or "rangemax" functions to get max values from 2 fields.
you can try using "nummax" or "rangemax" functions to get max values from 2 fields.