Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 rkpatelqlikview
		
			rkpatelqlikview
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Can anyone please explain how to count the no of sales except last 7 days from today.
Thanks in advance
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be this
Count(DISTINCT {<DateField = {"$(='<=' & Date(Today() - 7))"}>} Transaction_ID)
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be this
Count(DISTINCT {<DateField = {"$(='<=' & Date(Today() - 7))"}>} Transaction_ID)
 rkpatelqlikview
		
			rkpatelqlikview
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks Sunny.
Its working.
