Format expression in a label

[peterderrington]

Hi, 

Not sure if this can be done but i'm using the following expression as a label so that users can quickly see the numeric value in a graph but i want to limit the formatting to only 2 decimal places.

So the label expression is: =Concat('Mean Average Length of stay' & ' - ' & Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year])))

Whilst the expression its displaying is Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year]))

and i get this image:

Now thats lovely but as i say i'd like to limit that output to just 2 decimal places so that it shows as 12.42

Can it be done?

[zhadrakas]

you can try to wrap num() like this

=num(Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year])), '0,00')

[peterderrington]

No, i'm missing something, when i try the whole expression in the label field :

=Concat('Mean Average Length of stay' & ' - ' & =Num(Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year])),'0,0,0'))

I just get 'Error in expression'

Probably just missing a simple piece of syntax but i cant see it this morning

[zhadrakas · Accepted solution]

try these

=Concat('Mean Average Length of stay' & ' - ' & Num(Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year])),'0,00'))

=Concat('Mean Average Length of stay' & ' - ' & Num(Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year])),'0.00'))

[peterderrington]

It was the second one.

Thank you so much, very appreciated.