Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=sum( {$<Cal_Month = {"$(=month(today()))"}>} Sales)
=sum( {$<Cal_Month = {"$(=month(today()))"}>} Sales)