Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to use a simple set analysis function to return a figure from 13 months ago.
I have a master calendar with "MonthID" and just need to return the sum of LineInvoiceAmount.
Here's what I thought would work:
=sum({<[MonthID]={"=(only({1<DateID={'$(=num(date(today(1))))'}>}[MonthID] )-13)"},Description=>}LineInvoiceAmount)
I can enter :
"=(only({1<DateID={'$(=num(date(today(1))))'}>}[MonthID] )-13)"
into a text box and return the correct MonthID and I can filter on that MonthID manually and return the correct results, but I can't seem to get the function to work.
Any help wold be appreciated
Cheers
Chris
Try this
=Sum({<[MonthID] = {"$(=Only({1<DateID = {'$(=Num(Today(1)))'}>}[MonthID]) - 13)"}, Description>} LineInvoiceAmount)
Try this
=Sum({<[MonthID] = {"$(=Only({1<DateID = {'$(=Num(Today(1)))'}>}[MonthID]) - 13)"}, Description>} LineInvoiceAmount)
Genius Thanks Sunny