6 Replies Latest reply: Mar 30, 2018 8:13 AM by Pascal Dijkshoorn RSS

    Summing up times

    Pascal Dijkshoorn

      Hello,

       

      I want to create some formulas with two calculated fields. Both calculated fields (EXTRA_TIME_1 and EXTRA_TIME_2) are in the format 'hh:ss:mm'. I noticed something went wrong when I wanted to create some formulas with those calculated fields. I have made a simple table to show you the problem. When I display both fields as a dimension in the table, the field shows the correct value. But when I add a simple measure (EXTRA_TIME_1 + EXTRA_TIME_2), the value is not correct.  What is going wrong?

      $3D8072B1045B512D.jpg

       

       

      Thanks in advance.