I dont know in my case it is so weird if -ve is working then 0 is not working if 0 is working then -ve is not working. But both cases are not working.
can you attach workbook to help you?
I cant attach the workbook but i have given the screenshot here.. Let me know if this doesn't help much..
In the first screenshot it is weird i am getting the values like 16 or 32 like this rather than 8
and in the second screenshot i am getting 8 instead of 0 which i highlighted in red.
//WHEN -1 THEN 0
WHEN 0 THEN 0
ELSE ([Quantity]) END)
But if consider like this i am getting exact values (like 0 is converting as 0 and other values as exact like others but i still need to consider -ve also as 0)
i tried to create 2 calculations but again same issue didn't work for me..
lalitha, you would appreciate that it won't be helpful. If you can't post then email me. I will have a look.
Use the IF condition without aggregating with Sum.
IF [Quantity]<=0 THEN 0
IF [Quantity]>0 AND [Quantity]<1 THEN 0 // This will allow you to make the values where the quantity is just >0 to 0 without using ROUND.
ELSE [Quantity] END