I am trying to create a function that returns the number of billable actual work hours on a project. So far, I have this: SUM(CASE {projecttask.nonbillabletask} WHEN 'F' THEN {actualtime} ELSE 0 END) In theory, this should return the amount of any actual time that is billable, but it is instead returning a blank cell. Any ideas on how to make this work? I am implementing it as a custom entity field at the project-level, not in a saved search.

Maybe Test the individual components of your formula to ensure they work as expected. For example, try just SUM({actualtime}) to see if it returns any value.