Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=
sum({<MonthendDate = {"<=$(=Only(MonthendDate))"}, MonthendDate = {">=$(=addmonths(=Only(MonthendDate),-12))"}>} XXNET)
I am having difficulty with a set analysis, I am trying to have a chart show the monthenddate selected and the 12 months going backwards. My expression is not working , wondered if anyone can see what is wrong.
Thank you
Adrian
There's no example here...
try the following
sum({<MonthendDate = {"<=$(=Only(MonthendDate))>=$(=addmonths(=Only(MonthendDate),-12))"}>} XXNET)
Nimish
Unfortunately, your suggestion did not work either.
I have made a little example of sales for previous 3 months may you or someone else can help.
Regards
Adrian
example attached
Try
. Very similar but not the same. Do you have the same Monthend format in all records?sum({<MonthendDate = {">=$(=addmonths(Only(MonthendDate),-12))<=$(=Only(MonthendDate))"}>} XXNET)
Still not working see example
See example
There's no example here...
Thank you your expression works in my example document but I can not make it work in the document I am working on.
I have looked at the format of the MonthendDate and exported it to excel, the underlying date is a number with no rounding so I can not understand why it would not work.
Any more ideas?