Expand my Community achievements bar.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Calculated field on a custom form - hints and tricks?

Avatar

Level 1
I have recently spent a lot of time trying to create and troubleshoot a calculated field on a custom form - to find out that in some circumstances braces "{ . .. }" are required around some items - although I am not sure how to determine when they are required and when they are not. It is quite off-putting to a relative newby to see an invalid expression message appear as soon as "IF(SUM,,),,)" - both double-clicked from the expression builder - is entered. Does anyone have a collection of hints and/or tricks to use when working with calculated fields? I can't find anything particularly helpful on the HELP site. Thanks in advance Fred
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 7

the old link no longer works: https://experience.workfront.com/s/article/Calculated-data-expressions-679086747
I am searching for references but having no luck... if I find anything I will come back and paste a new link here.

Avatar

Community Advisor