Formula with set analysis doesn't appear to work

[#1]

Hi,

I'm trying to display the sales for the current month using the following formula -

=sum( {$<Cal_Month = {"=month(today())"}>} Sales)

The user can select a month however I still want one specific box displaying the current month's sales, hence the need for set analysis.

The funny thing is that if I use

=sum( {$<Cal_Month = {Jul}>} Sales )

it works fine.

Apologies if I am missing something totally straight forward - your help would be greatly appreciated.

Thanks in advance

C

[#2 · Accepted solution]

=sum( {$<Cal_Month = {"$(=month(today()))"}>} Sales)