Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I guess this is trivial but i am going nuts but can someone assist
I am trying to get a range between the last 3 months and today.
=sum({< YearMonth = {"'>=' & MonthStart(AddMonths(today(),-6)) & '<=' & MonthStart(AddMonths(Today()))"} >} Security_Total)
The range is confusing me when using within set analysis
May be this
=Sum({<YearMonth = {"$(='>=' & MonthStart(Today(), -3) & '<=' & MonthStart(Today()))"}>} Security_Total)
May be this
=Sum({<YearMonth = {"$(='>=' & MonthStart(Today(), -3) & '<=' & MonthStart(Today()))"}>} Security_Total)
Hi David,
May be you could try using this..
If you are specific with dates, then the one below.
Sum({<YearMonth = {'>=Addmonths(Today(),-3) <= Today()'}>}Security_Total)
if you want 3 months including the current month,
Sum({<YearMonth = {'>=Addmonths(Monthstart(Today()),-3) <=Monthstart(Today())'}>}Security_Total)
Hope it helps,
S