MDX Help

• gerhard.taute

  Newbie

  Points: 2

  More actions

  October 29, 2014 at 6:20 am

  #145428

  Hi

  I need to create a new calculated measure for converting my seconds into hh:mm:ss.

  I have the following mdx code but, get an error on the first "FORMAT" reserved word:

  iif([Measures].[Call Taking Time] = 0, null, FORMAT(Int([Measures].[Call Taking Time]/86400), "0:") +

  FORMAT( TimeSerial(0, 0, [Measures].[Call Taking Time] - (Int([Measures].[Measures].[Call Taking Time]/86400) * 86400)),"HH:mm:ss" ) )

  Can someone please assist?