2 Replies Latest reply: Jul 10, 2017 9:21 AM by Andrew Thomas RSS

    Percentage Values Obviously Incorrect

    Andrew Thomas

      Hi Everyone,

       

      I'm still fairly new to Qlik so please bear with me through this;

       

      I'm putting together an app that tracks opportunities and sales with an annual comparison element. As part of that I'm trying to create an expression that shows the success rate via a gauge. My expression is currently Sum([Sales Closed]/([Opps Created]-[Future Opps])) and I have formatted it to show the result as a percentage. However, the result is 11155% when I know it should be 39%.

       

      I've tried adding the Num function to the expression but it hasn't changed anything. Am I missing something obvious?

       

      Any help you could give would be much appreciated.

       

      Thanks!