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.
 
					
				
		
 IAMDV
		
			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
 
					
				
		
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
