I have a read only grid with a record type as source, I have three columns that has dynamic values. Meaning, I am using 4 or 5 record fields and get average these are custom fields.
value: recordType!field1+recordType!field3+recordType!field3 / 3 --Its a numeric field lets say field name is "Avg value"
then I have one drop down that suppose to filter the values in readonly grid based on slection.
If I select the value ">1" from drop down readonly grid should filtered and show only records have "Avg value" column >=1
I am not able to use queryFilter as I don't have appropriate value for "Field"
Discussion posts and replies are publicly visible
This will not work. The filter applies to the record data, but not to the calculated value in the UI. Did you consider to use a custom record field for this average?
Yes, actually this average is also dynamic, its based on Months values, for standard values like three,Six, I have custom field but there is option where user can select any no of months, for that I have problem.
OK. Then, this will just not work. You cannot sort data by an unknown dynamic value.
You cannot directly apply filters on custom fields in a record-source grid. Instead, you need to switch to a manual grid source using a custom expression. In this expression, fetch the required fields, calculate the dynamic average, apply your filter logic, and then pass the filtered list to the grid. This approach allows full control over filtering based on user selections, even for dynamically calculated values.Give it a try...