Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a text box, my expression shows 0.99088036603823 but no matter how I use the num format, I can't get it to show 99.x%. Any ideas?
=1-if(aggr(sum(pte_build)+sum(pte_design),month,PRIMARY_DEFINE_BODY)=0, aggr(sum(est_np_build)+sum(est_prod_build)+sum(act_np_build)+sum(act_prod_build)+sum(actual_design),month,PRIMARY_DEFINE_BODY),
aggr(sum(pte_build)+sum(pte_design),month))/sum([Available Hours])
This expression shows 1.00:
=num(1-if(aggr(sum(pte_build)+sum(pte_design),month,PRIMARY_DEFINE_BODY)=0, aggr(sum(est_np_build)+sum(est_prod_build)+sum(act_np_build)+sum(act_prod_build)+sum(actual_design),month,PRIMARY_DEFINE_BODY),
aggr(sum(pte_build)+sum(pte_design),month))/sum([Available Hours]),'##.#0')
Whoops. It was actually an issue with the Test in Chart in my Pie chart. Thanks!
@cbaqir try below
num(1-if(aggr(sum(pte_build)+sum(pte_design),month,PRIMARY_DEFINE_BODY)=0, aggr(sum(est_np_build)+sum(est_prod_build)+sum(act_np_build)+sum(act_prod_build)+sum(actual_design),month,PRIMARY_DEFINE_BODY),
aggr(sum(pte_build)+sum(pte_design),month))/sum([Available Hours]),'##.#0%')
Whoops. It was actually an issue with the Test in Chart in my Pie chart. Thanks!