Forum Discussion
Solved
IF AND statement give me a wrong result
I created a column called A Achieved which =1 if all total score>=1.8,classification=A else =0 Seems all result correct but 1, I don't know where is wrong, is it something wrong with the data or wi...
I fix the issue by changing data type from number decimal to number decimal fixed, and change back to number decimal
I cleanned the data, and did a test, when I set total impact as 2.8, then it will follow the fomula, so I don't think this is the data format issue, I think both classification and total impact were calculate correct, but don't know why it was not follow fomula when the result =1.8