Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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