This content has been marked as final. Show 2 replies
I have this aggr function
COUNT(XXX)/SUM(YYY) is calculating acheivement percent, what I'm looking for, is to get the date when it reached 98%, firstsortedvalue is not working (at least in the way I'm using it) because it is giving me the top date (equal to 100%). How can I limit the result of aggr only to be those >=98% so I can use firstsortedvalue.
Or if you have any other solution I'd really appreciate it, thanks in advance!