How to change to dollar amount with text object using sum of two fields?

[Anonymous]

Hello,

I am having an issue with trying to get the format of my expression in the text object box to result in a dollar amount ($) opposed to a decimal.

Here is the expression I am using:

=Sum([Queried Fin.Impact]) + Num(Sum([Non Queried Fin. Impact])

The result is a decimal rather than a dollar amount.

Any help would be appreciated!

Thanks,

Erin

[Peter_Cammaert · Accepted solution]

Use the Num() function but put it around the entire expression, not just the end part.

Like

=Num(Sum(...) + Sum(...), '$ #0.00')

Best,

Peter

[ziadm]

=Num(Sum([Queried Fin.Impact]) + Sum([Non Queried Fin. Impact]),'$#,##0.00')

[Anonymous]

Thank you both so much!