Forum Discussion

miked's avatar
miked
Contributor
3 years ago

Excel XFMemberProperty Errors

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

Excel Add In
  • miked's avatar
    miked
    Contributor
    3 years ago

    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.