Max Date by Row?

[microwin88x]

Hello,

I have the following table:

Month Year	=num(monthstart(max(CALE_DATE),1))	=sum({<EVENT={'BACKLOG'},BETA={">=43160"}>} QTY_INC)
Jul-2017	42948	0
Ago-2017	42979	0
Sep-2017	43009	0
Oct-2017	43040	0
Nov-2017	43070	0
Dic-2017	43101	0
Ene-2018	43132	0
Feb-2018	43160	0

The thing is Expression 2 isn't working well, because BETA field value is 43160 (fixed) and it should be the max value from each row (see expression 1).

I used this:

sum({<EVENT={'BACKLOG'},BETA={">=$(=num(monthstart(max(CALE_DATE),1)))"}>} QTY_INC)

Do you know how could I do to use the max for each MonthYear?

Thank you!!!

[sunny_talwar · Accepted solution]

May be using Aggr()

Sum({<EVENT={'BACKLOG'}>} Aggr(If(BETA >= MonthStart(Max(CALE_DATE), 1), Sum({<EVENT={'BACKLOG'}>} QTY_INC)), BETA, [Month Year]))

[Anil_Babu_Samineni]

May be this?

sum({<EVENT={'BACKLOG'},BETA={">=$(=num(monthstart(max(TOTAL CALE_DATE),1)))"}>} QTY_INC)

Or else, Can you check this in text box?

num(monthstart(max(TOTAL CALE_DATE),1))