13 Replies Latest reply on Aug 28, 2018 11:45 AM by Thomas Dodds

    problem with sum for timestampdiff




      I try to calculate Average Tenure (time of work) based on Vesting date and current date.

      In theory, it should be sum for work time divided by number of employees, but I have stuck with sum part


      Formula looks that way:

      timestampdiff(sql_tsi_month,"Person"."Vesting Date",current_date)/12


      I'm setting Aggregate rule SUM. But results are "strange". For two employees, where one has 14 years and second one has 7 years, as grand total it is displayed 182.


      Any idea what I'm doing wrong?