View Single Post
  #1   Report Post  
Marc Bobrow
 
Posts: n/a
Default why am I getting "#N/A"?

I'm using the Excel plug in for Hyperion software, and when I grab data from
a portion of the database that's empty, I get #N/A-- I'd like it to display
as zero. Is there a setting in Excel or a toolpak that will make what is
essentially "no data" appear as zero, rather than this error? (I never had
this problem in 5 years of working with the same Hyperion software and data,
but just got upgraded to an XP machine with Excel 2003)

Thanks,

Marc