Laurie, For simple totals, it is possible to add an EXCEL formula into a cell by starting the cell/formula with an '=' sign. This also works with CSV structured files, which EXCEL will load and convert on the fly.
Create a virtual/correlative field which will simply output the formula as text and add it to the CSV file e.g. "=SUM(An)". Cheers, David Murray .learn and do .excel and share -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Tuesday, February 12, 2008 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Excel downloads Hello, We are looking for a simple way to drop aggregate totals type reports out of Universe into Excel. Our users are using AccuTerm and we also have MITS Reports installed. But, neither one does the trick for summarized reports that use the DET-SUP option. Having the detail and forcing the users to do their own grouping/sub-totals in Excel is simply not an acceptable option here. UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be happy to develop a "simple" (key word...) VB.Net executable that works smoothly regardless of the version of Excel, as our users work on anything from Office 2000 and above. Any suggestions welcome. TIA, Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
