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

      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