Thousands separator in class function

[Pandatin09]

I am having issues getting the thousands separator to appear in the class function for the bin, I currently have the dimension set as this calculated field and i would like the bin values to include the thousands separator 

=text('$ '&dual(replace(class([Notional Amount in USD],vNotionalBin),'<= x <','- $'),class([Notional Amount in USD],vNotionalBin)))

The  vNotionalBin is the user variable that they can input to adjust the binning of this dimension to further drill down or to zoom out.

and count of another variable for my expressions tab which works fine.

[MarcoWedel · Accepted solution]

You could instead format your upper and lower bin amounts using the propper Money() function and concatenate the limits. 
To get a numerical value as well you then apply the Dual() function like you already did and skip the text() function because that would delete the numerical part you just before created with Dual().

So one solution could be:

Dual(Money(Floor([Notional Amount in USD],vNotionalBin))&' - '&Money(Floor([Notional Amount in USD],vNotionalBin)+vNotionalBin),Floor([Notional Amount in USD],vNotionalBin))

[Pandatin09]

Thank you Marco, your solution managed to replicate the class function and display the values in the format that i would prefer.

[MarcoWedel]

you're welcome.
Glad it helped