Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm using a fractile() where I'm getting a different result that is not equal to expected one.
My expression is like this:-
fractile({<year={'2012','2013','2014','2015'}>}Sales,.25)
there are some null or blank or zero values in year filed like sales(2013)=0 or sales(2014)=0 and so on...
that's why I'm getting the exact result.
I think this expression is not including the zero or something
So How can I include the zero values in Fractile()?
I think zeroes are included in the calculation but nulls are not. Perhaps
Fractile({<year={'2012','2013','2014','2015'}>} Alt(Sales, 0), 0.25)
I tried this but there is no change in output value same as earlier.
No increment or decrement in output value and same as earlier.
Would you be able to share few rows of data with the output you expect to see from it?
replace null to 'No Data'
I think a text value will also be ignored in the statistics functions like Avg and Fractile.
Hi Jonathan,
I have checked my database and I found that we have only numerical values like 11,33,45,0 and so on..
Two years have value where sales = 0 like 2012,2015
Hi Hashmi,
I have checked my database and I found that we have only numerical values like 11,33,45,0 and so on..
Two years have value where sales = 0 like 2012,2015
Hi Sunny,
I have checked my database and I found that we have only numerical values like 11,33,45,0 and so on..
Two years have value where sales = 0 like 2012,2015
Hi all,
This is the data where I'm using filter on season and games_missed
My expression is like this:-
fractile({<SEASON={'2012','2013','2014','2015','2016'}>}GAMES_MISSED,.25)
I'm not getting exact value.