Condition not working for certain records
Our requirement for this particular query is that if this specific key figure (KF1) is equal to 0, the entire row should not be displayed. In other words, a record should only be displayed in the query if KF1 is not equal to zero.
We used a condition for this. The condition is that if KF1 NE 0.
However, there are certain records that it does not show even though for those records KF1 is not equal to zero. That is, only two records show when there should four records.
Just to experiment, we tried using exceptions to see if the two records will be detected and they were. So what are we missing here? How come exceptions work for KF1 but not the condition?