Trying to create a new summary formula in a report that essentially looks at an op and if it is under 25K it is "under 25K" if it is over 100K then "over 100K" and everything else falls into "25-100" thoughts

If(Opportunity.ACV_Amount_New__c:SUM < 25000, "Under 25K", If(Opportunity.ACV_Amount_New__c:SUM > 100000, "Over 100K", "25-100K"))

  • try with this formula.. If(TEXT(Opportunity.ACV_Amount_New__c:SUM < 25000), "Under 25K", If(TEXT(Opportunity.ACV_Amount_New__c:SUM > 100000), "Over 100K", "25-100K")) Jun 7 at 16:39
  • Incorrect parameter type for function 'Text()'. Expected Number, Date, DateTime, Picklist, received Boolean
    – geohix
    Jun 7 at 16:41
  • Instead of summary formulas, you use bucket field to achieve your requirement. help.salesforce.com/s/… Jun 7 at 16:49
  • That works a lot better thanks
    – geohix
    Jun 7 at 16:59

1 Answer 1


Instead of summary formula, you can achieve this requirement by using bucket fields.

Ex: I have taken Annual Revenue field for bucket

Edit the respective report, from the left side pane under bucket field section, add the bucket field. Refer the below screenshot for your reference.

enter image description here

Once you click on Add bucket field you get with popup and choose the field you want to bucket. In your case ACV_Amount_New__c

Refer the below screenshot for bucket logic.

enter image description here

Refer the help article

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.