num format percentage

[cbaqir]

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')

[Kushal_Chawda]

@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%')

[cbaqir · Accepted solution]

Whoops. It was actually an issue with the Test in Chart in my Pie chart. Thanks!