I have two columns of data showing prices, say $1,100 in one and $2,200 in another. I want to display this as a range in a report as "Your price is $1,100 - $2,200". I used this formula:
"$" + $[Report Low Price]@row + " - $" + ($[Report High Price]@row
which returns "$1100 - $2200", how can i have it include the comma separator? The values range between $100 to over $1M (needing two commas per number).