Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

#error in formula row of the form sum([1])/2

s0uLr1pPeROct 31 2011 — edited Nov 9 2011

Greetings!

I have a necessity to use formula row in some forms to get an aggregated value of rows above, sometimes i have to use sum([1])/2 and this results me into a problem: in cells where formula is not valid (all values in specific column are blanks) it shows #error instead of values.

Question is, how to avoid that? like in excel for example =IF(A1="";"";A1/2)

Thanks in advance.

This post has been answered by JohnGoodwin on Nov 3 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2011

Added on Oct 31 2011

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

12 comments

2,439 views