on 2024 Mar 26 10:56 AM
Dear colleagues,
we need to find a way to identify the highest or latest value in a table by a formuala. In Excel you would pick the MAX formula BUT from what we tried in story report calculated column it is NOT Possible to use MAX formula.
Do you happen to have an idea here?
Thanks and BR
Martin
Hi maseitner,
I recommend using a crosstab table in your story. You can then create a calculation of type aggregation and use the MAX function. This should work.
Kind regards,
Jeroen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
4 | |
3 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.