How can we exclude '--' from the data.

[Anonymous]

I want to exclude the -- from the given data. Could any one please help me to do this. Its in table and want to exclude in designer part not thru the scripting part. Is this possible to write an expression in designer part which will exclude the -- from the table.

Best Regards,

Shubham

[kaushiknsolanki]

Hi,

    Let us consider that the field contained '--' is Field1.

    Now when you take textbox for that field you will see the value '--'.

    But to exclude that value you must use the expression listbox (i.e Create a new sheet object -> listbox -> properties- >fields -> select Expression.

    Type

    =if(Field1 <> '--',Field1)

    Same way you should use the expression in chart if you use that field in chart.

Regards,

Kaushik Solanki