3 Replies Latest reply: Feb 20, 2014 5:36 AM by Sara Titmuss RSS

    Target % Expression help

    Sara Titmuss


      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