Forum Discussion

tkrekeler's avatar
tkrekeler
New Contributor III
2 years ago

XFGetCell pulling random number for blank excel rows when dragging formula

When trying to format the report and create a space between sections users are seeing random numbers pulled from the formula. The XFGetCell is referencing blank cells, but somehow is still pulling in a number when trying to drag down formulas. This causes users to have clear out the formulas when copying down the xfgetcell. I would expect this to give an error, but not a number. Anyone else see this and know of a way to get around it? Added a screen shot below for reference.

 

 

Excel Add In
  • aricgresko's avatar
    aricgresko
    Contributor III
    2 years ago

    What's happening here is for any blank dimension in your XFGetCell string, OneStream will then reference your Cube POV for those missing dimensions.  Assuming one of those columns in your screen shot refers to the Entity or Account dimensions, you could put "None" as your Entity or Account member and it should return no data.