11 Replies Latest reply: Jan 8, 2013 4:10 PM by Josh Duenyas RSS

    What to do when "X" field is blank

      I'm trying to write an expression that says when the Bill Date is blank, calculate the difference in the sums of the Total Request Amount and Reimbursement Amount. Unfortunately, what I'm using below isn't working. Any ideas? Thanks in advance.

       

      =money(sum(if(Len(trim([Bill Date]))>0, [Total Request Amount]-[Reimbursement Amount])))