Hi,

This is an issue that I have solved a few times in the past, but it seems that my solution was never elegant, so I always forget how I did it.

I have a subtotal or/and a total which is a product of two numeric fields with 4 decimals each.
If I format as numeric/currency I get a ton of zeros.

What is the best way to get it as: $999,999.99

Thanks, Jonathan