exclude values

[#1]

Hello,

I`ve been trying to make a table chart so show a number of transfer orders with correspondig information such as : date , article number etc.

But our ERP software makes double entries for each transfer order. I need te suppress all entries from a certain 'Transfer-from Code' which is 'IN TRANSIT'
I`ve been trying to achieve this by making an expression such as

If([Transfer-from Code]<>'IN TRANSIT',[Transfer-from Code])

But this gives wrong values

any help would be welcome

[#2]

Hi,

if u have some expression u can filter this value with set analysis:

sum({<[Transfer-from Code]-={'IN TRANSIT'}>} FIELD)

But your if seems to be correct, can you post a qvw file with a data subset?

C u,

Stefano.

[IAMDV]

Stefano is right. Your IF condition seems to be right. I am assuming it is in upper case 'IN TRANSIT'.

What do you mean by wrong values? It will be easy to post the QV document.

Thanks - DV

[#4]

Thanks for all the input,

I`ve found the problem.

I used the formula as an expression.

Changed it to a calculated dimension and it gave the required results

thanks