Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I'm trying to do a basic thing, but I cannot work it out. I can do current month vs current month last year, but when I try to do this for Previous month vs previous month last year it doesn't work. I am trying to work out percentage difference
Here is my attempt:
((sum({<[Doc Date]={">=$(=MonthStart(AddMonths(Max([Doc Date]),-1)))<=$(=AddMonths(Max([Doc Date]),-1))"}>} [Net Value]))
/
(Sum({<[Doc Date]={">=$(=AddYears(MonthStart(AddMonths(max([Doc Date])-1)),-1)) <=$(=AddYears(AddMonths(max([Doc Date]),-1))"} >} [Net Value])))-1
This Last section does not work - I try to modify it from the current month vs current month last year but to avail. Please help 🙂
Many thanks,
Hi,
Change your below expression.
((sum({<[Doc Date]={">=$(=MonthStart(AddMonths(Max([Doc Date]),-1)))<=$(=AddMonths(Max([Doc Date]),-1))"}>} [Net Value]))
/
(Sum({<[Doc Date]={">=$(=AddYears(MonthStart(AddMonths(max([Doc Date])-1)),-1)) <=$(=AddYears(AddMonths(max([Doc Date]),-1),-1))"} >} [Net Value])))-1
Hi,
Change your below expression.
((sum({<[Doc Date]={">=$(=MonthStart(AddMonths(Max([Doc Date]),-1)))<=$(=AddMonths(Max([Doc Date]),-1))"}>} [Net Value]))
/
(Sum({<[Doc Date]={">=$(=AddYears(MonthStart(AddMonths(max([Doc Date])-1)),-1)) <=$(=AddYears(AddMonths(max([Doc Date]),-1),-1))"} >} [Net Value])))-1
Thank you for your swift response. It works, I just thought I'll add a comment as there was a comma missing 🙂
((sum({<[Doc Date]={">=$(=MonthStart(AddMonths(Max([Doc Date]),-1)))<=$(=AddMonths(Max([Doc Date]),-1))"}>} [Net Value]))
/
(Sum({<[Doc Date]={">=$(=AddYears(MonthStart(AddMonths(max([Doc Date]),-1)),-1)) <=$(=AddYears(AddMonths(max([Doc Date]),-1),-1))"} >} [Net Value])))-1
Many thanks