formatting number of minutes

[ali_hijazi]

Hello

got a pivot table with Dimension = TPK and an expression which is as follows:

avg(aggr($(vDuration.AvgDuration.Current),TPK,JOB_ID))

in one of the cells I have the value of 138 (number of minutes)

in a text box if I write the following:

Interval#( Time#(138  ,'mm'),'hh:mm') then I get 2:18 displayed however if I write the below:

Interval#(

  Time#(

  avg(aggr($(vDuration.AvgDuration.Current),TPK,JOB_ID))

  ,'mm'),'hh:mm')

I get null on the chart

Please advise

[sushil353]

Hi,

Try to use number tab in chart property, there you can find interval selection to get the desired output.

HTH

Sushil

[ali_hijazi]

I tried this but it didn't work as well it kept displaying 138

[anbu1984]

Can you post sample app

[ali_hijazi]

it is because avg(aggr($(vDuration.AvgDuration.Current),TPK,JOB_ID)) returns decimals

suppose I have 122.75 then I get null but if I use floor it gives 2:02