Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having a problem with an AGGR because when I add this part into the syntax it stops working showing the correct amount (it doesn't affect the current expression)
COUNT(if(AGGR(RANGESUM(ABOVE(SUM(Monto),0,ROWNO())),(Mes, (IdType, (=SUM(Monto), Descending))))<0.75*SUM(TOTAL Monto),1,0))
How about if you do this
Sum(Aggr(
If(RangeSum(Above(Sum(Monto), 0, ROWNO())) < 0.75 * Sum(TOTAL Monto), 1, 0)
, Mes, (IdType, (=Sum(Monto), DESC))))