Exporting distributions to excel
When exporting distribution data to excel it would helpful to have the quarterly averages, number of quarters and percentage listed in separate columns.
Hello, Thanks for your time in the idea lab. This message is to let you know we are going to archive this idea based on the level of engagement in comparison to other idea lab items. The reason we do this is to keep the Idea Lab clean and up to date based on feedback from clients like yourself. Keep in mind this idea may exist somewhere else in the Idea Lab, a quick search may give you a similar idea with higher engagement. Also, feel free to recreate this idea if you would like to, and keep in mind specific wording can help people find and vote for your idea. If you have any questions, issues, or concerns please let us know! Thank you.
-
Susan Lotreck commented
This would be a bonus to have the export dump this info into separate columns with the Quarter headers too! For now, I use "text to column" to get the qtrly avg and the 20 qtr fund balances into separate columns and then take the time manually enter Qtr1-FY etc. headers too (a pain!). Our agency fundholders will request to see this report annually.
-
Wendy Ponting commented
It woud also be helpful to include the funtid as some funds have the same fund name