2 Replies Latest reply: Jan 7, 2013 10:20 AM by carickhoffc RSS

    IF formulas for date fields

      I want to write an expression for a chart that says if the bill date field is populated, sum the total request amount. I have most of it but I don't know what to put in place of 'Billed'. Any suggestions?


      =sum(if([[Bill Date]]= 'Billed', [Total Request Amount]))