Recent content by Warren Meads

  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

    Thanks @Ben Hill who's suggestion on making sure there is a completely flat hierarchy has solved this issue so have closed the thread Warren
  3. W

    Closed Strange behaviour on sequence function

    The formula is already restricted to the Same hierarchy used in the SEQUENCE function The Hierarchy being used only has one parent and 12 N Level elements under it. The first position is calculating correctly even though there is only the C element before it. Initally I thought it might pick...
  4. W

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

    Thanks Ben. I do not recall seeing the Change AND @ symbols in the documentation. Can you please advise what these do. On the @ statement I assume the value of Parent will the value after all feeder cells have been calculated and if the calculation using the @, changes the parent then you...
  5. 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...
  6. 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...
  7. W

    Closed Cell unlock in If Statement

    Thanks Grantham. Yes I discovered the " Continue" earlier and reports it works
  8. 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.
  9. 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...
See more