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

    problem with sum for timestampdiff

    aPsikus

      Hi,

       

      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?