Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I encounter a problem in using aggr. Hope someone can give me some help, much appreciate!
How do I get the first expression of the same result as the second expression?
Attached Example Aggr.qvw
PS: Sorry for my English
try with (and check it!)
Sum({$< AÑO=, MES= , Date = {"<=$(=DATE(MonthEnd(Max(Date))))"} >}
Aggr(SUM( {$< AÑO=, MES= , Date = {"<=$(=DATE(MonthEnd(Max(Date))))"} >}
Sales ),Group, Id, Description,Type))
try with (and check it!)
Sum({$< AÑO=, MES= , Date = {"<=$(=DATE(MonthEnd(Max(Date))))"} >}
Aggr(SUM( {$< AÑO=, MES= , Date = {"<=$(=DATE(MonthEnd(Max(Date))))"} >}
Sales ),Group, Id, Description,Type))
Excellent !!
Thank you very much