Calculated field in Search Filter

[Deadpool]

 I want to filter the records on the result of the calculated field that I created. I want to add a search field for that. Here is the formula that I am using "SELECT SUM (HFA_Publisher_Split) FROM L_License_Detail_List WHERE Track_ID = target.[@field:Track_ID]" . Can you please help me in this regard?

[Kenzo]

Unfortunately, it is not possible to create a search filter in a Calculated field. As a workaround, you can create an actual field in your table and create an Application Task for your calculation instead.

You can refer to the following as an example.

1. Create an actual field that will populate the records from the child table based on the Calculation that you have.

2. Create a Task that will SUM the HFA_Publisher_Split records from the child table and pass it to the parent table targeting the Track ID. 

 

[NiceDuck]

As @Kenzo stated, DataPage search form cannot search values from calculated fields. Values of calculated fields are determined on DataPage load while the search form filters the records directly from the DataBase. From the Search form's perspective, the values of the calculated fields are yet to exist. 

You can use trigger and Task to repopulate values in your table so that the search form can search on them. Formula fields could work too! But only if the values you are computing does not include values outside the records.