# Median need Help

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

• # Median need Help

Hey,

how can I realize a Median Function (Statistic) with the Enterprise Rules in Palo?

Any Idea?

Thanks
• Hi,

I don't think that there is a built-in function in the Palo rules set, that would do that. But if you can provide an excel based example (without using the median function) we can try to help you figuring out how to implement the calculations with rules.

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

The post was edited 1 time, last by tish1 ().

• Hi,

the first example i have three values from the month jan_08 ( 20 ); jan_09 ( 15 ); jan 10 ( 30 ). From these Values I want get the median with a Enterprise Rule construction.

the second example i have six values from the month jan_10 ( 20 ); feb_10 ( 15 ); mar_10 ( 30 ); apr_10 ( 5 ); may_10 ( 45 ); jun_10 (25). From these Values I want get the median with a Enterprise Rule construction.

I know, I can solve such a problem with excel and push Rules.
But I must solve it with the Enterprise Rules, because we want run all arithmetic operations in the Palo OLAP server.

Regards

The post was edited 2 times, last by nebukadnezer ().

• Hi,

I went through the instructions for calculating the median and after a second thought, I have to say, that my assumption was probably wrong. I think it's not possible to do the calculation in Palo Rules with the current function set.
I don't see how it would be possible to sort values (in our case it must be done in a sub-cube) and pick the one in the middle.

But sure I'd like to be proven wrong on this one.

Source:
easycalculation.com/statistics/learn-median.php

Please write a feature request in the bug-tracker.

Regards.

ps. one workaround could be exporting the data through ETL Server and precalculating the figures through the available scripting extensions und reimporting them to your model...
Robert Tischler
Senior Consultant Vector SW DV GmbH