Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try to attach your app or sample data
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 ??