Forum Discussion
Terrible at filtering.
So we have a workflow for engineers where they document their time against an opportunity, that once sold gets turned into a project, that they may then again document their time against. I'm trying ...
stretcharm
Memorable Member
Memorable MemberPersonally I try to avoid blanks/nulls and replace them with a dummy value.
I would also add a conditional column in M(Query Editor) or computed column to Set the Type e.g. Opportunity/Project
You could also then have 2 conditional colums/computed column or measures for Opp Time Billed and Project Time Billed.
They could be aggregated without a filter.