Changing decimal value to time format in expression error.

[GotianSA]

Hi,

I am hoping someone would be able to assist with the problem I have. I have a data set that stores the quantity of actions in a column. The quantity stored of 2 actions (Travel Time and Bytes Labour) is time values stored as decimal values.

 I am using the below expression to convert these values to time format based on the Demand Description column. It seems to work except for one of the values that stays in decimal value. Why this is happening or how to resolve this problem would be greatly appreciated.

 =IF(MATCH([bpart_descr],'Travel Time','Bytes Labour'),Interval(qty/24,'hh:mm'),[qty])

[Zhandos_Shotan]

Very strange thing..

Make sure your [bpart_descr] dim with only one distinct 'Travel Time' value.

Have no idea about other reason.