use translation table in calculated field
John G asked 7 years ago
Is there a way to include a translation table value in a calculation? We have a translation table that is retrieving a portion of a GL account. I need to concatenate the translation table value with an account value from my data source.
Answers
Lorren Zemke Staff answered 6 years ago
John,
I just created a new KB article for this. http://www.eonesolutions.com/help-article/mimic-translation-table-calculated-field/
You cannot use the Translation Table in a calculated field, so you would have to mimic the translation table logic within the calculated field and then concatenate your additional values to that result.
I just created a new KB article for this. http://www.eonesolutions.com/help-article/mimic-translation-table-calculated-field/
You cannot use the Translation Table in a calculated field, so you would have to mimic the translation table logic within the calculated field and then concatenate your additional values to that result.