Hello everyone,
I am trying to select those projects, whose sum of revenues are between a range (vRevenueMin, vRevenueMax)
I have tried the below equation, but is not working for me.
aggr(ONLY({<AGGR(SUM(RevenueAmount), project_name) = {">=$(vRevenueMin)<=$(vRevenueMax)"}>}project_name),project_name)
project_name, RevenueAmount
A, 100
A, 70
B, 30
C, 10
I appreciate your help!