Search results

  1. W

    Question Struggling with Syntax

    I have the following Rule restricted on a single N level element in the Projects Dimension. All other dimensions are restricted to all N level elements IF(CHILD("Projects","Default" ,"Projects Total",3) = Link("Budget and Forecast" ,[ "Periods:Total","Project" ]) , 300 ...
  2. W

    Closed Strange behaviour on sequence function

    I am calculating a running YTD total across 12 Months by picking up the last months calculated YTD value and adding a normal Hierarchy total. This I believe is not an out of the ordinary calculation. Here is the function restricted to "Total Income YTD" SEQUENCE("Periods", "Default", -1...
  3. W

    Question Complex formula to populate an element with the sum of all the other elements under the same parent.

    Hi Can any one help with the formula required for this. I am populating a specific element with an amount from another cube and want to subtract from this the value of all other elements under the same parent. This can not be done in the dimension hierarchy as the specific element populated...
  4. W

    Closed Cell unlock in If Statement

    I have an if statement that populates a N level cell with a value if true. If the if function resolves to False for that particular Cell then I would like that cell to be open for user input. I can not find a function that appears to do this. Any suggestions.
  5. W

    Request New to Modlr and would like documentation on Excel addin

    Is there any documentation on the way the excel modlr functions work. I have "copied" a modlr workspace to excel and this displays correctly but I can not get writeback to work. The cell with the modlr function cubeget is replaced by the values entered. The cubesend function looks like it is...