Forum Discussion

CCI01's avatar
CCI01
New Contributor
3 years ago

Excluding a base member when running an XFGet at a Top member

Hi,   I have a saved report setup with XFGets. One of the dimensions on the report points to the member "Top." Is there a way to have the XFGet show Top of the dimension and exclude a base member...
Excel Add In
CCI01's avatar
CCI01
New Contributor
3 years ago

Thanks for the recommendation on the alternate hierarchy. I will be skip that since this is more like a one off request.

 

I’m still new to XFGets. How would you write a subtraction of an XFGet within the same cell to exclude the base member?

aricgresko's avatar
aricgresko
Contributor III
3 years ago

=XFGetCell(xxx,xxx,xxx,xxx,"Top",xxx,xxx,xxx)-XFGetCell(xxx,xxx,xxx,xxx,"Base",xxx,xxx,xxx)

The key thing to note is that you need to full XFGetCell strings... you cannot subtract members within the same dimension inside 1 XFGetCell.  You can do that in Quick Views, however, using a GetDataCell (examples found under Samples in the Member Filter Builder).