Description:
There are some attributes that do not show up for configuration in the filter section nor in the [Build Power Filter] page. There are some attributes that are available for configuration in the filter section and not in the [Build Power Filter] page. Here is one example. Can you please explain why the attributes cannot be configured and used in filtering?
Creating a user-defined custom calculated attribute on any object is not showing as an available attribute for configuration in a power filter. The example below is given for the Project Object, but the issue can be reproduced on other objects too.
Steps to Reproduce:

1. Login to Clarity as an administrator

 

1. Admin Tool > Objects: Project > Attributes

 

1. Click ‘New’ button

 

1. Attribute Name = ‘My Calculated Number Attribute’

 

1. Attribute ID = ‘my_calc_number’

 

1. Data Type = Calculated

 

1. Result Data Type = Number

 

1. Click ‘Save’ and configure the calculation

 

1. Current Expression Absolute(12345)

 

1. (it does not matter how the calculation is defined)

 

1. Add the attribute to the following views

 

1. Views > Project List : [Layout]

 

1. Views > Project Filter : [Layout]

 

1. Be sure that the ‘Allow Power Filter’ option is selected

 

1. Main Application > Projects

 

1. Note: you can see the field in the Project List View and in the Filter Section

 

1. Click [Power Filter]

 

1. Select ‘Project’ in the Left : Object field

 

From the ‘Field’ pull-down look for ‘My Calculated Number Attribute’

Expected Result: The calculated attribute should appear as an available attribute.
Actual Result: The calculated attribute is not available for selection.
Solution:
This is not a defect.
Calculated, Formula and Virtual attributes are not to be used in a power filter.
The Calculated and Formula type attributes can be used on the Filter Layout in conjunction with a power filter as an ‘AND’ condition.For more information on virtual attributes read the Solution section on TEC534847.
These types of attributes can be used on the Filter Layout in conjunction with a power filter as an ‘AND’ condition.
“Solutions provided by CA Technologies”