stbrooks13
New Member
- Joined
- Dec 9, 2014
- Messages
- 40
I have "unpursued costs" (the amount of money we spent attempting to pursue a candidate, but did not end up pursuing) for which I don't have filter/slicer information for. Source, gender and diversity are unknown for these costs because we did not get to the point in the recruiting process to know/track these fields. When these unknown filters/slicers are selected, the unpursued costs remain as is, when I would like for them to appear as 0. How should I write these formulas so that they appear as zero when unknown filters/slicers are selected? Note that "unknown" is not an option as a selection for the filters/slicers AND the unpursued costs are on a different table. Thank you for your help!