Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
im looking for a way to show the sum of the past 12 months....
Somehow, the formula doesnt work:
Sum({<Date={">=$(=(Monthstart(addmonths(Today(),-12))))<=$(=MonthEnd(addmonths(Today(),-1))))"}, Country={"Italy"}>}Sales)
The retrieved values are not the correct result...their 10x times higher...as if they were multiplied with something...
Any ideas?
Thanks!
As below , replace YYYY-MM-DD to match the format of your date field
=Sum({<Date={">=$(=Date(Monthstart(Today(),-12),'YYYY-MM-DD'))<=$(=Date(Monthend(Today(),-1),'YYYY-MM-DD'))"}
, Country={"Italy"}>}Sales)
i suggest start with a simple table where you have monthstart of date as dimension and just do a sum for Italy. that could lead you to the issue
As below , replace YYYY-MM-DD to match the format of your date field
=Sum({<Date={">=$(=Date(Monthstart(Today(),-12),'YYYY-MM-DD'))<=$(=Date(Monthend(Today(),-1),'YYYY-MM-DD'))"}
, Country={"Italy"}>}Sales)