Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
May be using Aggr()
Sum({<EVENT={'BACKLOG'}>} Aggr(If(BETA >= MonthStart(Max(CALE_DATE), 1), Sum({<EVENT={'BACKLOG'}>} QTY_INC)), BETA, [Month Year]))
May be using Aggr()
Sum({<EVENT={'BACKLOG'}>} Aggr(If(BETA >= MonthStart(Max(CALE_DATE), 1), Sum({<EVENT={'BACKLOG'}>} QTY_INC)), BETA, [Month Year]))
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))