Forum Discussion

RustyShacklefor's avatar
RustyShacklefor
New Contributor III
4 years ago

XFgetcell pulls in future months as YTD negative

How can I get xfgetcell formula to not pull in the next month as a negative? i am making a YTD file and currently have Jan and Feb number but march pulls in the YTD amount but negative and causes the...
Excel Add In
MarkHoughton's avatar
MarkHoughton
Contributor
4 years ago

Hi,

Many thanks for that, though the first line should be Dim ObjViewMember

Dim ObjviewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId)

Then it works perfectly.

Mark

aricgresko's avatar
aricgresko
Contributor III
4 years ago

Other than changing the variable name you declared (viewMember vs. ObjViewMember), what's the difference?  It accomplishes the same thing, just personal preference?

  • MarkHoughton's avatar
    MarkHoughton
    Contributor
    4 years ago

    Hi,

    Well it just gave me a compile error until I changed it, that's all. Otherwise, perfect. Appreciate your help in resolving this.

    Mark

    • aricgresko's avatar
      aricgresko
      Contributor III
      4 years ago

      Interesting - I don't have any compile issues.  Either way, glad it's working for you!