13 Replies Latest reply: Dec 1, 2011 12:33 PM by maibangbee RSS

    Expression Total

      Hi All

       

      For some reason, When I use the expression total for the below IF Statement, it seems to display as true even though we are in Nov. - NUM(month(today())) is definitely greater than data in January - Please see attached for illustration.

       

      Expression

      =IF(Month_PurNum<=NUM(month(today())),SUM(JanValue_Pur),SUM(Jan_P))