Skip to main content

Hi Everyone, 

 

I am trying to filter the 'Sum of Total Value' field, which is summarizing all our invoice line items. I want to see the areas with the highest value and I don't know how to add a filter for a summary rollup field. 

 

Is it possible? 

 

Thanks!

8 respostas
  1. 16 de fev. de 2022, 07:58

    Hello,

    Thanks for this detail.

    As a last resort if you are not able to filter by this field yet only want to show records that are > 50,000 then you could create a formula field that returns a checkbox TRUE or FALSE value based on the amount using a IF formula on the record itself.

    eg. IF (Amount__c > 50000, TRUE, FALSE)

    You'd need to swap Amount__c for your own API name.

0/9000