3 Replies Latest reply: May 24, 2016 6:31 AM by Kilian Riera RSS

    crazy time duration expresion.

    Kilian Riera

      hi there!

       

      Attached you can see a strange and weird stuff is happening to me.

       

      This is a KPI, where i can put the actual month time average duration. If i set the Measure and format from the menu to "Duration" no matter if i use time(avg(CodiDataCalcDiffHoraInici)) or time(avg(CodiDataCalcDiffHoraInici),'hh:mm') i get the correct result: -01:21

       

      Then i want to put it on the subtitle to show actual and previous month value. Like " Actual Time: -01:21 Previous Time: 02:03 "

       

      duration.jpg

       

      But the problem is that when i put the expression on the Appearance menu

       

      duration1.jpg

       

      It shows 22:38 not -01:21 like the expresion set on the Measure menu.

       

      I'm trying to search about the expresion "duration" time format or something like that but no luck by now.

       

      Any idea?

       

      thanks in advance.

       

      Kilian