& in chart expression

[Anonymous]

Hi,

I am trying to add a custom duration expression to my line chart.

Using...

=FLOOR((AVG(IF(TEU=1,UnpackTime)/3600)))&'h'&ROUND(MOD(ROUND(AVG(IF(TEU=1,UnpackTime))),3600)/60)&'min'

...seems to work great in a Text Object however when using this same logic within Line Chart>Properties>Expression>Definition the chart returns blank as per below:

When I remove the &'h' and &'min' the values are displayed on the chart (as per below) but not in the format that I require. Obviously the addition of custom suffixes ('h' and 'mins') is causing the chart to display blank values.

Can someone please tell me how I can get 'h' and 'mins' added to the chart data points so that it is displayed as 3h29mins for example?

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

=Dual(FLOOR((AVG(IF(TEU=1,UnpackTime)/3600)))&'h'&ROUND(MOD(ROUND(AVG(IF(TEU=1,UnpackTime))),3600)/60)&'min',FLOOR((AVG(IF(TEU=1,UnpackTime)/3600)))&ROUND(MOD(ROUND(AVG(IF(TEU=1,UnpackTime))),3600)/60))

[Anonymous]

Booyakasha!

Thanks a stack it worked a treat!

[Anonymous]

What?

booyakasha

1. (slang) used to express triumph, normally if trying to appear a "gangsta".

Apologies if I offended you lol