How to use a Predefined Column of a Task in the Fast Formula.

Summary

How to use a Predefined Column of a Task in the Fast Formula which is not present in the database items in the Fast Formula.

Content

Hi All,

I have a requirement in my Compensation Plan where in i have to load median salaries based on Employee's Country, his department and his new proposed band. I am able to use the Proposed Grade field in promotions task under Configure Worksheet Display. But i have to now use this Proposed Grade field to configure the median salaries.

For this i am using a user defined column of numeric type but since the data is too large so it is taking lot of effort for me to manually enter each value like below.