Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 revoori123
		
			revoori123
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I have two fields days,approvals+denials in that my set is [year type]= {'Current'} ,i want to calculate median for using that condition for
the two fields.an you please help me out this
 YoussefBelloum
		
			YoussefBelloum
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
try to attach your app or sample data
 revoori123
		
			revoori123
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Data:
load * inline
[ Month,year,days, approvals
Jan,2017,9,8
Feb,201710,7
Apr,2016,23,15
Mar,2017,17,12
May,2017,5,3
jun,2017,1,0
jul,2017,34,25];
my formula sum(days)/sum(approvals),, i wnt median for the for that formula for year 2017
 
					
				
		
You want output for median formula is 12 or 17 Mar 2017?
Are you trying to get 1.41 from given data as Median ??
