Convert one worksheet column value to another column using daily rates
As part of the workforce compensation plan, we have configured the below-mentioned columns:
The Group Head Recommendations is the editable column where the manager will enter the recommended bonus amount in local currency based on several factors. Once the plan is live the manager will enter the amount in this column.
The Group Head Recommendations in AED is the another column where the amount entered in Group Head Recommendations amount has to get converted using the daily conversion rates added in the system. As of now we are adding the conversion rates in the dynamic column calculations.
We need to know what will be the other work around through which we can directly use the conversion rates used in manage daily rates page from the system instead of hardcoding the daily rates in the dynamic column?