Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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