Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Need help on the accumulate last 4 completed month on expression, tried several ways not working need some help 🙂
Expected output as below & attached QVF.
if(YearMonth=max(total YearMonth),0, RangeSum(above(sum({$<YearMonth={"<=$(=Date(Addmonths(max(YearMonth),-1)))>=$(=Date(Addmonths(max(YearMonth),-4)))"}>} Value) ,0,4)) )
?
if(YearMonth=max(total YearMonth),0, RangeSum(above(sum({$<YearMonth={"<=$(=Date(Addmonths(max(YearMonth),-1)))>=$(=Date(Addmonths(max(YearMonth),-4)))"}>} Value) ,0,4)) )
?
Thanks!