5 Replies Latest reply: Mar 8, 2013 8:25 AM by grains85 RSS

    Strange Chart for Expression

      Hi. I have one listBox for startTimes and one listBox for endTimes in the format: "yyyymmddTHHmmss".

       

      I am using the "mid()" Expression function to only retrieve the hours, "HH" from this string and show the total hours in a Chart.

      But it seems like I do something wrong because the result of the chart should be:

       

      15-13 + 15-13 = 4
      

       

      But of some reason it shows the result as 48. Any ideas why?

       

      Attached the listboxes and chart.