Clarity PPM - Unable to create formula for calculated data type

Article Id: 192914

Status: Published

Updated On: 12-06-2020 15:08

Products:

Clarity PPM SaaS , Clarity PPM On Premise

Issue/Introduction:

I am experiencing following error when i am entering a formula in calculated data type attribute:

ODF-0010: Invalid expression. Check the format to make sure it is correct.

Cause:

In this instance the "Constant" field of one of the attributes was populated with a string of text for the name of an attribute.

Environment:

Release : 15.6

Component : CA PPM SAAS APPLICATION

Resolution:

Select the desired field using the "Attribute ID" field instead. Only attributes that are numeral in nature will display in this list.

Additional Information:

If you wish to use a lookup field as the attribute, it must be a lookup - numeral, otherwise it will not display in the list of attributes.

Some details on creating a "Lookup - Numeral" is located here: