Excel XFMemberProperty Errors

[miked]

Hi All,

For some reason, we are getting errors (#Error) when we use the XFMemberProperty function in Excel with Account for the following 3 Member Properties; Input View for Adjustments, No Data Zero View for Adjustments, and No Data Zero View for Non-Adjustments.  Every other property returns a value or a blank cell which is what we want.  Any idea why these properties cannot just return a blank cell as opposed to showing an error?

Thx,

Mike

[miked]

One follow up..if there is a value in these 3 properties, it returns that properly.  But when we don't have a value stored in them, it returns an error.