Clarity PPM - Unable to create formula for calculated data type

book

Article ID: 192914

calendar_today

Updated On:

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:

https://knowledge.broadcom.com/external/article?articleId=23075