Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a table with IDs and associated times and values. Now I want to show in a table diagramm the maximum value of all entries, which are in a time certain time range around the selection.
I imagined something like this, which doesn't seem to be correct, yet.
max({$<ID = , Time <= AddMonths(max(Time), 1)>} Value)
also tried
max({$<ID = , Time <= $(=AddMonths(max(Time), 1))>} Value)
but to no avail. Am I on the right track?
Regards,
Sandro
maybe you can try
max({$<ID = , Time={"<= $(=AddMonths(max(Time), 1))"}>} Value)
Can't make that work either. Wouldn't the expression in quotes also evaluate to a boolean? And when comparing Time to it, never get me anywhere?
Either way. Unfortunately, not yet the solution
Sandro