Sum String Returning Negative

[qliky88]

Hi Experts, 

I have a simple sum(Status = 'Opened') KPI however it is returning -8 as opposed to +8

Any ideas? 

Thanks 

🙂 

[sunny_talwar · Accepted solution]

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')