Is it possible to use a field as the "value" in the list view filter criteria?

Question

I would like to customize a list view to filter for the second of three payments being overdue within a custom object. It would be simple if I could filter for balances that are greater than the value of an existing formula (currency) field called "One Third Total Fee".

Field = Balance

Operator = greater than

Value = One Third Total Fee

The total fee differs by account, so it's not just a matter of filtering by Balance + greater than + $XXX.XX

So, is there a function, formula or trick to tell the filter criteria for value to pull the calculated amount from the field? It seems like this should be possible because the value criteria can use the function "TODAY" when filtering a date field.

Thanks for your input!

Deepak K Anand · Accepted Answer

Unfortunately, NO.   You will have to create another Formula Field that does this math and may be returns/outputs a YES or NO and use that as a Criteria in your List View.

Sherilyn Thomson · Answer

Thank you Deepak!

Is it possible to use a field as the "value" in the list view filter criteria?

Data Management

関連学習

さらにヘルプを表示