MEDIAN CALCULATION

[nevilledhamsiri]

Hi Dear all,

I need to calculate median (middle value) of the given data set under two Branches (MY00 & KW00). The aggr function given there wont get me the correct value. Kindly advise me what changes to be done in to the formula?

Thanks a lot.

Neville

[nevilledhamsiri]

Now the script error was gone & I can see the created new fields such as F1 & Median, but to populate the value for Median, what next to be done?

[nevilledhamsiri]

Dear Friend

Most of the issues I had seems to have resolved. To populate the value for median, expression to be made for Paid amount. Now the median for both Branches are visible as per the file attached.Many many thanks for helping again & again. Also if possible,let me know how the median is computed with out adding inline data. In other words, can we do this in the original data itself. Also please let me know the possible aggr function to get this results

Thanks

[nevilledhamsiri]

If possible please let me have the Aggr() function for the same calculation. I have almost got what needed from your guidance. Thanks a lot.

Neville

[Taoufiq_Zarra · Accepted solution]

as you can see Neville its just aggr(Median(F2),F1)

[nevilledhamsiri]

Thank You very much

Nevile