cancel
Showing results for 
Search instead for 
Did you mean: 

Condotion working strange

Former Member
0 Kudos

Hello

I noticed strange way of working of the condition in my query. I built the report which contains two characteristics in lines (shop, article) and three columns (value 1, value 2, difference). I built the condition like "difference <> 0" do present only the combinations to be explained. The matter is that it works perfectly, but not in case, when the summary of differences is 0. For example, when I have two lines with differences, one is "2" and second is "-2", the report presents no lines. For another selection, I can have for example three differences, like "1", "2", "-4" - in this case report will give me those three lines as a result.

Any idea?

Arelis

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Arelis,

Please check in your query designer if "supress Zero" is active for Rows and column. If yes select "Do Not Supress" You will find this option in Query Properties -> Rows/Column.

Regards,

kams

Former Member
0 Kudos

Hello

I just checked - I had "Do not supress".

Arelis