5 Replies Latest reply on Apr 20, 2012 6:22 AM by justin.goodrich

    sum(iif([date]==today(),[arbitrary variable 2],0))

      [date] is a timestamp and I'm not getting the expected result i.e not receiving all orders for today with the following formula.

       

      sum(iif([date]==today(),[arbitrary variable 2],0))

       

      Does anyone see an issue with the formula. I've vetted with no avail.

       

      Thank you.