8 Replies Latest reply on Mar 6, 2012 7:47 AM by allysonwinters2

    If statement calculation

      Hi everyone,

       

      I would like to calculate the % of claims that for which the following field (Initial Reserve in Hours) is less than 72 hours for each salesperson out of the total of all claims.  My results are either blank or 100%.  This cannot be right there should be a value good or bad for every salesperson.  here is the formula I am using:

       

       

      IF(SUM([InitialReserveInHours])<72 )then SUM([ClaimID])end/sum([ClaimID])

       

      Thanks

       

      Allyson