Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking to use a text box to show the % achieved for sales against target. What I have tried for far is =(TARGET/SALES)*100, =sum(TARGET/SALES) and =sum(TARGET/SALES)*100 to see if this would work and it doesn't (surprise surprise)! It either returns a - or a large number.
Can someone advise the best way getting this to show the decimal % or the %?
Thanks
Hi Sara, try this
=Num(Sum(TARGET)/Sum(SALES),'#,##0%')
and if you want 2 decimal places then =Num(Sum(TARGET)/Sum(SALES),'#,###.##%')
Where Num() function is used to format the individual summed up values for TARGET and SALES.
Hi Sara, try this
=Num(Sum(TARGET)/Sum(SALES),'#,##0%')
and if you want 2 decimal places then =Num(Sum(TARGET)/Sum(SALES),'#,###.##%')
Where Num() function is used to format the individual summed up values for TARGET and SALES.
To format a number as % you need:
Num(myExpression,'#.##0,00%')
but this is only the final part of the problem,
I don't know how your data work but try these expressions in your text box and then combine:
SUM(Target) and Sum(Sales) if they work try
SUM(Target) / Sum(Sales)
let me know
Subodh Roche, worked a treat! Thank you!