11 Replies Latest reply on Jun 22, 2018 9:57 PM by Anisha Jhamb

    Create a calculated Field with 2 different date fields

    Tapiwa Tapiwa

      I have a calculated field Called Current Year Book-to-Approve_Numerator used to provide funded count. To derive this number I use the Shaw Upload date (Funded Count),

      SUM(IF YEAR([Shaw_Upload_Date])=YEAR(TODAY()) THEN [Funded Cnt] END)

      I also have a calculated field Called Current Year Book-to-Approve_Denominator used to provide Approved count. To derive this number I use the Initial received date (Approved Count)

      SUM(IF YEAR([Initial Received Date])=YEAR(TODAY()) THEN [Approved Cnt] END)

      These numbers match with the business, now they want a step further to calculate Book to Approve calculated field .  The formula is simple,

      Funded Count/Approved Count.

      The problem is the 2 fields are calculated using different date fields.   Those numbers do not match what I have on the attached excel spreadsheet. Approved Count is using Initial Received Date while Funded Count is using Shaw Upload date

      How to I make that calculation work.  Your help will be much appreciated