Home » Developer & Programmer » Reports & Discoverer » Formulas not calculating NULL values in Oracle Financial Analyzer
Formulas not calculating NULL values in Oracle Financial Analyzer [message #204531] Tue, 21 November 2006 03:14 Go to next message
ShwetaAgarwal
Messages: 1
Registered: October 2006
Junior Member
Hi All,

I have created a report that does calculation on few financial data items. But if any financial data item is NULL then the end result is also NULL whereas i need the result in values.

Eg Actual Budget
A 100
B 50 25
C 50

C is a formula A-B. for budget i need -25 but it's bringing null.

Please help me to resolve the issue ASAP.

Thanks n regards

Re: Formulas not calculating NULL values in Oracle Financial Analyzer [message #204568 is a reply to message #204531] Tue, 21 November 2006 05:22 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Any operation which includes NULL value results in NULL unless there's a NVL function which would then convert it to acceptable value. In your case, it seems that NVL(something, 0) would do the job.
Previous Topic: Print Selected Page from Report
Next Topic: Security / admin reports?
Goto Forum:
  


Current Time: Fri Dec 09 02:16:10 CST 2016

Total time taken to generate the page: 0.08373 seconds