I have a quick question .... In our organisation , we are asked to add Weighted average yield to the existing report .. Can any one please let me know how to calculate that ?
Unlike the arethmitic average there is no single function (like avg for arethmitic average) that performs the calculation. It is a 2-step exercise , first calculating the
2 aggregates and finally performing the division:
total(number * value) / total(number)
The query provider would fetch the individual aggregates and the final step is the division (which can be on the client or on the webserver depending on the tool)
Thanks steve. But i did it ... Actually they were asking me to add wtdavgyield for account details report since this is a financial org.. And i did it with the formula
Wtavgyield = =Sum(Percentage([Securities Transaction Net Amt])*[Securities Transaction Daily Yield %])
And i got it and my manager is happy abt it
Thanks once again for everyone who loked into my problem and helpmed me out with that
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.