Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
Can anyone suggest me how to calculate median of below expression in straight table.
Num(MAX( {<Status= {'Open'}>} DateEnter, DateEnter)-(MIN( {<Status= {'Close'}>} DateClose, DateClose)),'#,##0')
Thanks.
There isn't a direct median-function available but you could use rangefractile() for this, see: Re: Running Median calculation.
- Marcus
median ([{set_expression}] [ distinct ] [ total [<fld {,fld}>] ] expression )
Returns the aggregated median of expression iterated over the chart dimension(s).
This function has the same limitations for nested aggregation as the avg([{set_expression}] [ distinct ] [ total [<fld { , fld } >]] expression) function. The median function supports Set Analysis and the total qualifier in the same way as the avg([{set_expression}] [ distinct ] [ total [<fld { , fld } >]] expression) function.
Examples:
median( X )
median( X*Y/3 )
median( total X )
median( total <Group> Price )