Hi, long-time lurker, first-time poster.
I am new to using cube functions and have run into an issue using cubeset. I am trying to report on PROD1, PROD2, and PROD3 revenue all in the same cell. Using the following cube formulas, I get a negative value as a result. However, the correct result should be the absolute value of that result (i.e. postive). So, for example, 2+2+2 is coming back as -6 instead of 6. Does anyone see an issue with my code that would be causing this? Thanks!
=CUBEVALUE("Cube",D7,D5,D8,D14,A33,"[DataSrc].[TotalWithAlloc]","[RptCurrency].[USD]","[Scenario].[H1].[ALL SCENARIO.H1].[FCTotScenarios]")
D7 = CUBEMEMBER("Cube","[Category]")
D5 = CUBEMEMBER("Cube","[Segment]")
D8 = CUBEMEMBER("Cube","[Organization]")
D14 = CUBEMEMBER("Cube","[Time]")
A33 = CUBESET("Cube","{[RevAccount].[PROD1],[RevAccount].[PROD2],[RevAccount].[PROD3]}","test")
Bookmarks