Target % Expression help

[#1]

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

[#2 · Accepted solution]

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.

[alexandros17]

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

[#4]

Subodh Roche, worked a treat!  Thank you!