Number format issue in text box

[Anonymous]

Hi all

I'm having an issue getting the number format right in a text box.

The expression is:

=num(sum(CallIn)+sum(Callout)+count(Mails)+count(Id))/HourDivider

It gives me the answer I require but where do I place the NUM to format the answer to two decimal places?

Many thanks in advance

[Anonymous · Accepted solution]

Maybe something like this :

     =num( (sum(CallIn)+sum(Callout)+count(Mails)+count(Id))/HourDivider , '#.##0.00' )

[MK_QSL]

Use below (Same as Bill Replied)

=Num(YourExpression,'#,#0.00')

[Anonymous]

Excellent! Thanks! All I was missing was the second bracket after NUM!

[Anonymous]

As I have said before:  Slippery blighters them brackets.