Skip to Main Content
Forums

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!

#VALUE in Excel for a formula using a missing cell with function builder

757673Jun 21 2010 — edited Jun 21 2010
Forum,

When I use function builder to retrieve data from HFM in Excel, I have a problem with formulas using this data when it is missing.

If I put nothing in the #nodata / missing label replacement, then SmartView puts "" in the cell, which creates an error if I try to sum it with something else ( = "" + 1,234.56 returns #VALUE).

SmartView doesn't let me me use 0 as a replacement value... I found a workaround by using .0 as the replacement value, but I imagine there is probably a more elegant way to solve this problem.

Let me know if you have an idea.

Thanks,

Julien
This post has been answered by Erich Ranz on Jun 21 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2010
Added on Jun 21 2010
#business-intelligence-applications, #financial-consolidation, #hfm, #performance-management-applications, #smartview
2 comments
1,033 views