cancel
Showing results for 
Search instead for 
Did you mean: 

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

tdiehl12
Explorer
0 Kudos
162

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? 

View Entire Topic
xavierlegarrec
Product and Topic Expert
Product and Topic Expert
0 Kudos

 

@tdiehl12 We do have the standard payRange field that does what you are trying to do (as long as you've integrated your template with the EC pay ranges and have adjusted the Display settings to Min-Max in Plan Setup > Display Settings) however it looks like you are customizing a lot of things here and are not leveraging the standard payRange integration with EC.