Skip to content
+1-888-319-3663

COMMUNITY FORUM

use translation table in calculated field

John G asked 5 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 5 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.

If you would like to submit an answer or comment, please sign in to the eOne portal.