Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

Like

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

Best,

Peter

View solution in original post

3 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Specialist
Specialist

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

Anonymous
Not applicable
Author

Thank you both so much!