topic Format text into Money in QlikView

Format text into Money

Fri, 31 Jan 2014 11:59:05 GMT

Hi,

I have the following expression in a text object:

=round(sum(TARGET)) which returns 349520169. As I want the total of all targets

However, I want this shown as £349,520,169.00. I have tried the functions tab and can't seem to get to grips with it. Can anyone help??

Thanks.

Anonymous — Fri, 31 Jan 2014 12:02:46 GMT

Try

=num(round(sum(TARGET)),'£#,##0.00')

rustyfishbones — Fri, 31 Jan 2014 12:15:31 GMT

try

MONEY(SUM(Target))

Fri, 31 Jan 2014 12:34:40 GMT

Adrian, that worked perfectly thank you!!!