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.