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

Report message to a moderator

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: 21823
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.

Report message to a moderator

Previous Topic: Print Selected Page from Report
Next Topic: Security / admin reports?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 07:09:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.