Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a simple sum(Status = 'Opened') KPI however it is returning -8 as opposed to +8
Any ideas?
Thanks
🙂
This happens because Status = 'Opened' is evaluated as True or False. When true, it returns -1 and when false it returns 0. Try this instead
Count({<Status = {'Opened'}>}Status)
or you can also do this
-1 * Sum(Status = 'Opened')
This happens because Status = 'Opened' is evaluated as True or False. When true, it returns -1 and when false it returns 0. Try this instead
Count({<Status = {'Opened'}>}Status)
or you can also do this
-1 * Sum(Status = 'Opened')