How to add currency column in a employee saved sea...
# ask-stanley-ai
n
How to add currency column in a employee saved search?
c
AI generated answer (using internal Slack threads):
To add a currency column in an employee saved search, you can use the
{subsidiary.currency}
field. This field automatically defaults to the base currency of the associated subsidiary of the employee. Here are the steps to add this field to your saved search: 1. Navigate to the saved search you want to modify. 2. Click on the 'Results' subtab. 3. Click on the 'Add New Field' button. 4. In the 'Field' dropdown, select 'Formula (Text)'. 5. In the 'Formula' field, enter
{subsidiary.currency}
. 6. Click 'Save'. Please note that this will display the currency code (e.g., USD, EUR) and not the currency symbol (e.g., $, €). If you want to display the currency symbol, you would need to use a CASE WHEN statement in your formula to map the currency codes to their respective symbols. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.866076112
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848419368
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.845790744
Please provide your feedback on this answer.