concat several sum expressions values

[Anonymous]

Hi everybody, does anybody know if is there a way to achive the following string:

(150,200,300) asuming that these 3 values are the result of three expressions with a given date(vDateRotura)

sum({<CalendarDate={"$(=max(date(vDateRotura-1)))"}> }  Qty)

sum({<CalendarDate={"$(=max(date(vDateRotura-2)))"}> }  Qty)

sum({<CalendarDate={"$(=max(date(vDateRotura-3)))"}> }  Qty)

I think that I should you use the CONCAT  function with this expression in some way using this expression, and maybe the RANK??

sum({<CalendarDate={">=$(=max(date(vDateRotura-3)))<=$(=max(date(vDateRotura-1)))"}> }  Qty)

Thanks in advance

[Anonymous · Accepted solution]

I finally found it with this one

=concat ( IF( aggr ( Rank( sum({<CalendarDate={">=$(=max(date(vDateRotura-3)))<=$(=max(date(vDateRotura-1)))"}> } Qty)),CalendarDate)<=3, aggr(sum(Qty),CalendarDate) & chr(10)))

Hope can be useful