Set analysis expression

[apthansh]

I have the below expression  and it doesn't work.Any help is appreciated.

=sum({<[Expense Month-Year]={'$(>=MonthName(Today())& <= monthname(AddMonths(today() ,11))'},

             [Subspace Commence]={'$(< addmonths(today(),12,'MM/DD/YYYY'))'}>}Finalamount)

Thank you very much.

[Chanty4u]

try this

=sum({<[Expense Month-Year]={'>=$(=MonthName(Today())& <= monthname(AddMonths(today() ,11))'},

             [Subspace Commence]={'<$(= addmonths(today(),12,'MM/DD/YYYY'))'}>}Finalamount)

[sunny_talwar]

Incorrect syntax, try this:

=Sum({<[Expense Month-Year] = {"$(='>=' & MonthName(Today()) & '<=' & MonthName(AddMonths(Today(),11)))"}, [Subspace Commence] = {"$(='<' & Date(AddMonths(Today(), 12), 'MM/DD/YYYY'))"}>} Finalamount)

Not sure if this will work, but the syntax should be better with the above expression

[Anil_Babu_Samineni]

Try this?

=Sum({<[Expense Month-Year] = {"$(='>=' & MonthName(Today()) & '<=' & MonthName(AddMonths(Today(),11)))"}, [Subspace Commence] = {"$(='<' & Date(AddMonths(Today(), 12), 'MM/DD/YYYY'))"}>} Finalamount)