ExcelValue for =Sum-function in Excel
Posted: Mon Jun 04, 2007 3:25 am
How do I assign an ExcelValue for a textfield that generates a correct sum-function when exporting to excel.
In excel the syntax for a sum-function is something like this: =SUM(B14:B19).
And the sum-function I´m using in the StimulReport-designer is this: {Sum(Service.Cost)}
When I generate an excel-document from my repport, I can get it to be translated to the number-format in excel by copying that function in the report to the excelvalue-property. But It would be helpful if I somehow can get it to be translated as an excel-sum-function
In excel the syntax for a sum-function is something like this: =SUM(B14:B19).
And the sum-function I´m using in the StimulReport-designer is this: {Sum(Service.Cost)}
When I generate an excel-document from my repport, I can get it to be translated to the number-format in excel by copying that function in the report to the excelvalue-property. But It would be helpful if I somehow can get it to be translated as an excel-sum-function