Forum Discussion

RustyShacklefor's avatar
RustyShacklefor
New Contributor III
3 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
aricgresko's avatar
aricgresko
Contributor III
3 years ago

We use UD8 as a Reporting Helpers dimension and have a Scaling hierarchy to scale the data in whole numbers, thousands, or millions.  If U8#None was selected, we would see the inverse number as you're describing.  Since the members in my screen shot below are DynamicCalc's, we do not see those inverse values.  My second screen shot shows how this works in a quick view.