Hi Jonnie, (just to get some clarity)
Thanks for your question. Are you trying to just reduce the formula to make it easier to read?
Are you having any issues with the result, or is the result OK?
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
hi sir Tarello,
The formula is working but it is showing the wrong result. I want to show the conversion rate %...
The formula below shows me the right result. but when i want to devide these counts by an other count, it gives me the wrong result