• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cubevalue function with comparative operators

A

Aleksandar

New Member
Hi everyone I have a following problem which I am trying to solve.
I have following function: In cell B13 I have number 2017 which is input parameter for year. I have following function: =CUBEVALUE("ThisWorkbookDataModel";"[b2b_settleamountcur]";"[Year of closed].["&B13&"]") which sums all amount where year is 2017. How can use following logic to sum all amounts where year of amount is less than 2017. I tried to use "<"& B13 but it doesn work like in sumif function. Is it possible to use comparative operators in cubevalue function. Workbook which I am working on I don't have at the moment available to post.
 
You can't do calculation itself in CUBEVALUE function. What it does is simple aggregation of values/measures already present in data model.

So first, you'll need to add appropriate measure in the cube/model before you can do what you are looking for.

Or alternately, add some grouping column that serves as expression in the cube/model.
I.E. [YearFlag] where you assign True/False based on < Year selected.
 
You must log in or register to reply here.
Back
Top