Home » Developer & Programmer » Reports & Discoverer » Calculation exports as formula in Excel (OracleBI Discoverer 10g (10.1.2.2) Windows XP)
Calculation exports as formula in Excel [message #382919] Mon, 26 January 2009 05:59
curufin
Messages: 1
Registered: January 2009
Junior Member
I have a report that uses a calculation like this:
Column J +( Column J*Column K/100 )

When I export the report to Excel the relevant cells contain a formula e.g. =J2+(J2*K2/100).

Is there any way to cause the value to be exported to Excel rather than the formula?

If I export the report to CSV first and then open it in Excel then the values are exported but I don't want the user to have to do this when they run the report.
Previous Topic: report page break
Next Topic: HELP: Discoverer Error
Goto Forum:
  


Current Time: Tue Dec 06 14:21:17 CST 2016

Total time taken to generate the page: 0.07470 seconds