1 Reply Latest reply: Jul 27, 2012 9:20 AM by Wojciech Parzyszek RSS

    Formula with set analysis doesn't appear to work

    Chirag Chhatralia



      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