Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there a Median function in ReportNet?

function median reportnet
0
Posted

Is there a Median function in ReportNet?

0 CommentsAdd a Comment

1 Answer

0

No the Median function is not currently available in ReportNet. These types of functions (median, percentile_cont) are complex aggregate functions rather than scalar (or single row) functions. We’re currently unable to map the complexity of these as user-defined functions. A workaround would be to use Tabular SQL to achieve the required results.

0 CommentsAdd a Comment

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123