cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate median

Former Member
0 Kudos

Hi

I have to calculate median on Age. here Age is nothing but the difference between the created date and today's date.

how to do this in reporting.

Thanks

Shiva Shankar

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

There is not statistical type formula operators in BEx. You best bet would be to do this with a standard Excel formula for Median. (i.e. MEDIAN(range of age values))

Thanks,

Jeff

former_member188325
Active Contributor
0 Kudos

its not difference between created date and today's date?these posts show how calculate difference between dates..right?

Thnaks

Former Member
0 Kudos

hi murali

yes it is correct. but i need median

I have Product number as char and Age as Key figure. i need to display median on product level

Thanks

Shiva

Former Member
0 Kudos

Hi murali,

I think you should define an exit variable to load todays date an then create a formula with the dates differences.

Could you please provide an example of what you want?

regards,

Sebastián.-

former_member188325
Active Contributor
0 Kudos

Hi,

take a look at these threads

/message/84901#84901 [original link is broken]

Hope this helps

Former Member
0 Kudos

H Murali

I need the information how to calculate the median.

Thanks

shiva