4 Replies Latest reply: Nov 15, 2016 4:02 AM by Sébastien Fatoux RSS

    Need to change into d:hh:mm format

    Mohammad Sarif

      Hi All,

      I have an filed called MTBF which is in Minutes.

      The expression is below:

       

      (((Outage_Sys_MonthEndDate - Outage_Sys_MonthStartDate)*24*60) - sum(Outage_OutageDuration)*1440)/count(distinct Outage_sys_id)

       

      I am doing below to change the format:

       

      interval((((Outage_Sys_MonthEndDate - Outage_Sys_MonthStartDate)*24*60) - sum(Outage_OutageDuration)*1440)/count(distinct Outage_sys_id) , 'd:hh:mm')

       

      But still it is showing in minutes.

      Please help.

       

      Sarif