Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have calculate percentage by :
sum(inbound_orders)/sum(actual_receipts_qty)
by my percentage calculation is exceeding 100 ...
How to achevie the percentage value.
Note: I am using pivot table ....I didnt get any relative option on my template...(no option)
and I also tried this expression : =sum(inbound_orders)/sum({1} actual_receipts_qty)
try this
num(sum(inbound_orders)/sum(actual_receipts_qty),'##00%')
see attachement