Forum Discussion
Date Hierarchy Displaying too much data
Sorry forgot the calculation.
% Change from Budget = IF(
(SUM(em_encounter_fact_date_agg[Pt Volume])/ sum(em_encounter_fact_date_agg[adj_arrivals_budget]) - 1) = -1 && ([Pt Volume Change %] = 0) && [Staff Hours % Change] = 0, 0, SUM(em_encounter_fact_date_agg[Pt Volume])/ sum(em_encounter_fact_date_agg[adj_arrivals_budget]) - 1
)
I have the IF because without it, the future months were showing as -100.00% and causing havoc with the Percentage Total.
% Change from Budget = IF(
(SUM(em_encounter_fact_date_agg[Pt Volume])/ sum(em_encounter_fact_date_agg[adj_arrivals_budget]) - 1) = -1 && ([Pt Volume Change %] = 0) && [Staff Hours % Change] = 0, BLANK(), SUM(em_encounter_fact_date_agg[Pt Volume])/ sum(em_encounter_fact_date_agg[adj_arrivals_budget]) - 1
)
Try with this change, basically you are saying if you don't have any value then % will be blank. I assumed you assigned value to 0 to not to show -100%