Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Want to display last 12 months sales data.
My columns are
yearmonth which is a number
Amount which a sales amount filed
So can you please guide me how to get the last 12 months data?
Please do the needful
Thir
If yearmonth is a seq no then you may use expression something like -
Sum({$<yearmonth = {“>=$(=Max(yearmonth ) – 11)<=$(=Max(yearmonth ))”}>} Amount )
try this expression
rangesum(above(Sum(Salesamount),0,12))
see this example
or see the below link using which you can do the same from script itself
Hi,
Check
Thanks,
AS
Hi
YearMonth is a time stamp and it is a num datattype
So please do the needful
Thiru
Hi AS
It's not working
=Sum({<YearMonth={‘>=$(=MonthStart(Today(), -11))<=$(=Today())’}>}Amount)
showing error
and
=sum({<YearMonth={">$(=monthstart(max(YearMonth),-12))<$(=monthstart(max(YearMonth)))"}>}Amount)
It is showing 0
So
what i have to use exactly?
Hi
It's not working
=Sum({<YearMonth={‘>=$(=MonthStart(Today(), -11))<=$(=Today())’}>}Amount)
showing error
and
=sum({<YearMonth={">$(=monthstart(max(YearMonth),-12))<$(=monthstart(max(YearMonth)))"}>}Amount)
It is showing 0
So
what i have to use exactly?