Add Commas to A Text box

[dsohn]

Hi I have a text box similiar to the one below:

="Your savings is $"&Int(Abs([Sum[Savings]))

The Sum([Savings]) is referencing another number in my report. And I had to make it an integer and absolute value because if I didn't it would show a negative sign and bring in 10 decimals.

The end result is "Your savings is $12387"

Is there a way I can add in a comma onto that number?

Thanks

 

[RedSkies]

Try it like this:
="Your savings is $"& Format(Int(Abs([Sum[Savings])), "Standard")

However, that will show the number with a decimal point and two zeros.

If you don't want that, I think you'd have to replace "Standard" with "#,##0"