Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I want to hide a row in one of my list boxes. The list box is my table Scenario, where I have "Budget 1" "Budget 2" "Budget 3" and "Current budget". The last one will always represent Budget 1, 2 or 3. Having a current budget makes it a whole lot easier when creating static tables, however it does make it (only slightly) confusing as there are two rows that represent the same data. So my question is, is it possible to hide this row?
 
					
				
		
 IAMDV
		
			IAMDV
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		What is the name of this Field? Is it Scenario or Scenario_ID?
If it is Scenario then use :
=IF(Scenario <> 'Current budget', Scenario)
If it is Scenario_ID then use :
=IF(Scenario_ID <> 'Current budget', Scenario_ID)
Can you post the QV document? or the screenshot?
 
					
				
		
Thanks for your help! I now figured out what i had done wrong. I had chosen field Scenario and in addition written an expression  instead of chosing expression as a field.... Me being a bit slow 
Thanks again 
 
					
				
		
 IAMDV
		
			IAMDV
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You are welcome! I am glad you have got it working.
Cheers - DV
