Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
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
as you can see Neville its just aggr(Median(F2),F1)
Thank You very much
Nevile