Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 DS14
		
			DS14
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please suggest how can I calculate Sum of QTY_VAL and multiply by selected day bucket .
 Gysbert_Wassena
		
			Gysbert_Wassenasum(QTY_VAL) * [day bucket]
 
					
				
		
 DS14
		
			DS14
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		How to create day bucket, which will count days only for selection, like if i select 5 days in calendar then bucket should be for 5 days, if i change selection then days count will change
 
					
				
		
 DavidŠtorek
		
			DavidŠtorek
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Try something like this
Count( distinct DATE)
 
					
				
		
 jonathandienst
		
			jonathandienst
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You may be better off creating and uploading a small sample QVF app file to illustrate your requirement and ensure accurate and relevant help. It does not need to be real data, but it should reflect the fields and tables of the real app and include the table you want and exactly what results you would lie to see.
 
					
				
		
 jyothish8807
		
			jyothish8807
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Deepak,
Try this sample:
Br,
KC
 
					
				
		
 DS14
		
			DS14
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		There is no sample mentioned
 
					
				
		
 jyothish8807
		
			jyothish8807
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi ,
I have attached a qvf file.
You can try this exp also:
if(GetSelectedCount(Date)=0,Sum(Sale),
Sum(Sale)*GetSelectedCount(Date)
)
Br,
KC
