This content has been marked as final. Show 3 replies
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 %?