I am trying to customize an existing Report to filter based on a formula field. It was created with a Custom Report Type of My Object with Child with Grand-Child. Now we want to filter it based on a custom field which we can match against $User.Username to determine if it should be displayed (when it matches). We can write this formula at any of the three levels, but it is not showing up in the available fields to filter on. Is it not possible based on this report type?

I've tried Checkbox, Number, and Text as the formula type, on all three objects. None of them are allowing me to filter, despite the fact that some of the pre-existing formulae seem filterable.

1 Answer 1


Each time you add a new field to the object(s) used on a custom Report Type you have to go to this Report Type record and drag this new field to the layout (click on Edit Layout button first) The funny thing is that I was doing this just a minute ago in my org :)

  • Phew, man I thought I was going crazy. WOOT!
    – Adrian Larson
    Commented Jun 23, 2016 at 23:06
  • And it's not Friday yet ))
    – o-lexi
    Commented Jun 23, 2016 at 23:13
  • Awesome!! It saves my day.
    – herr
    Commented Mar 18, 2019 at 9:33

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .