Format text into Money

[#1]

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 · Accepted solution]

Try

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

[rustyfishbones]

try

MONEY(SUM(Target))

[#4]

Adrian, that worked perfectly thank you!!!