Formatting a number in a text field

[#1]

Hi All,

I have an expression used in a text field and I would like to format the result to be limited to only to digits after the comma and with a procent (%) sign.

=

'Open vs. Closed Ticket Ratio: ' & Count(If((Ticket_List.Status='Closed'),Ticket_List.Ticket))/Count (Ticket_List.Ticket)

the result is displayed as a 14 digit number currently. I have seen the fromatting syntax before but I can not find it again.

Thanks for your help.

Matthias

[#2 · Accepted solution]

Matthias,

here you go:

'Open vs. Closed Ticket Ratio: ' & Num(Count(If((Ticket_List.Status='Closed'),Ticket_List.Ticket))/Count (Ticket_List.Ticket), '#.##0,00')

Have also a look in QV help for Num# and Num.

Good luck!

Rainer

[#3]

Thanks Rainer, this has done the trick.