Skip to main content
M
miked
Contributor
December 9, 2022

Excel XFMemberProperty Errors

  • December 9, 2022
  • 1 reply
  • 0 views

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

1 reply

M
mikedAuthor
Contributor
December 9, 2022

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.

Terms & ConditionsAccessibility statement