Combining Market Min and Market Max in a new field to create the "Market Range"

[tdiehl12]

We added custom fields on our Annual Compensation template; "Market Min" and "Market max" are pulling into 2 separate columns on our template and are pulling directly from EC onto the template. I'd like to also add a "Market Range" column which would display the custom fields Market Min and Market max as follows:

"Market Min - Market Max"

What formula can I use to display the two fields with the "-" in the middle? 

[xavierlegarrec]

@tdiehl12 not that I know of. It's a workaround that comes with this limitation unfortunately. You could try adding roundUp(toNumber()) as a wrapper in the formula but I don't think it will work.

All the best

Xavier