7 Replies Latest reply on Jul 25, 2018 7:38 PM by Deepak Rai

    LOD Difference not showing correctly

    Wendy Weber

      I have 2 LOD expressions where I do a unique count over the employee ID  if the employee is  added or termed.  I then find the difference between the "Add LOD" minus the "Term LOD".   Some of the calculations are problematic.  For example, employee ID = 16 which has the role of CEO and it has one "Term" record and no "Add" record. The difference shows zero but I want it to show -1.  See the attached workbook for details.  Thanks you!!