Skip to main content
I am creating an ACTIVITIES report and want the criteria based on the account owner. I am looking for activities made on the account by someone other than the account owner.   Instead of creating a separate report for each user with a criteria of "Account Owner equals Jane Doe" isn't there a way to have the criteria "Account Owner equals USER.ID" or something like that?
2 个回答
  1. 2017年12月20日 16:58
    Sorry hit [Answer] too soon

     

    Select 

     

    Datatype = Formula

     

    Result = Checkbox 

     

    Formula = 

    CreatedBy.Id = Account.OwnerId

    Then use the Checkbox field = TRUE or FALSE as your Report Filter

     

     
0/9000