Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 master_student
		
			master_student
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello community,
I would like to set a condition
if sum(poktndd) >0 and IS NOT NULL(LB) => sum(poktndd)
else don't display the amount / sum(poktndd)
Any idea please?
Thanks
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		So like this?
If(Len(Trim(LB) > 0 and Sum(poktndd) > 0, Sum(poktndd))
 master_student
		
			master_student
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		there are errors in your expression
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Yes my bad, I forgot a parenthesis within my first condition:
If(Len(Trim(LB)) > 0 and Sum(poktndd) > 0, Sum(poktndd))
 master_student
		
			master_student
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Is your field name all Upper case? May be this:
If(Len(Trim(LB)) > 0 and Sum(POKTND) > 0, Sum(POKTND))
These are things we won't know so you have to make sure that you take care of them at your end
 master_student
		
			master_student
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks for your help sunny. The fields names are correct.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		So did it work or not?
 master_student
		
			master_student
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		no 
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Have you tried clicking ok to see if you see any result or not? Where are you using this condition? Would be able to share screenshots of your LB and POKTND/poktnd field? To make both our life easier, would you be able to share a sample?
