Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys ,
could you please help me in solving the below expressions.
Sum({<Datum = {">=$(=MonthStart(AddMonths(Max(Datum),-9))) <=$(=Monthend(AddMonths(Max(Datum),2)))"}>}Belege_Qty_Ordered)
above expression is not working, it is working for only current expression.
not working for Rolling 12 Months
can you try this?
=SUM({< DateNum = {">=$(=Date(MonthStart(Today(),-11),'MMM-YY'))<=$(=Date(MonthStart(Today()),'MMM-YY'))"}
>}Belege_Qty_Ordered)
or
rangesum(above(sum(Belege_Qty_Ordered),0,12))