Issue with straight table

[#1]

Hi All,

   I have a two straight tables where i am suppose to show the variances and Variance % with ascending and descending sort order

.I mean both the tables have same data but sorted ASEC and DESC. As i dnt want to replicate the same data in two tables have decided to show the tables (Overages - Where I will show only the variances where the value is >=0) and (Underages -- Here i would show as <0).

I am not sure why the cilck view is intoducing the new values in to the table when I put a condition to the variance >=0.All rows highlighted in red are newly added rows.

Please let me know if you have any suggestions.. Thanks in advance...

[deepakk]

hi,

Can you attach the application. Also try the following.

Enable only the first expression and check if the new data is getting added. Try this exercise on each expression.

You will come to  know that from which field this new data is getting added.

Also check if suppress null and suppress missing is enabled. You will find it in the presentation tab.

Deepak