topic Number format issue in text box in QlikView

Number format issue in text box

Anonymous — Thu, 08 Oct 2015 12:33:19 GMT

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 — Thu, 08 Oct 2015 12:39:05 GMT

Maybe something like this :

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

MK_QSL — Thu, 08 Oct 2015 12:40:41 GMT

Use below (Same as Bill Replied)

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

Anonymous — Thu, 08 Oct 2015 12:40:46 GMT

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

Anonymous — Thu, 08 Oct 2015 12:42:54 GMT

As I have said before: Slippery blighters them brackets.