+ Reply to Thread
Results 1 to 1 of 1

Cubset returns negative values

  1. #1
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2007
    Posts
    1

    Cubset returns negative values

    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")
    Last edited by Skewerer; 05-16-2014 at 12:07 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to write a formula that returns a zero for negative numbers
    By thesongbirdsociety in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2012, 02:33 PM
  2. Excel 2007 formula returns negative numbers
    By bensonsb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-06-2012, 09:15 PM
  3. Negative Returns
    By mick2 in forum Excel General
    Replies: 2
    Last Post: 02-25-2009, 12:04 AM
  4. Replies: 4
    Last Post: 09-26-2005, 06:05 PM
  5. [SOLVED] formula returns (correctly) a negative value
    By brit64 in forum Excel General
    Replies: 5
    Last Post: 09-19-2005, 04:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1