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.