NEXEL on Web

Ian Bradley
Ian Bradley Customer
Fourth Anniversary 25 Up Votes 5 Likes Name Dropper
edited August 2020 in Platform
We recently upgraded to 10.6 and I had a dataview with a lot of cell based deep entity nexel formulas, pulling from other columns (blocks). I accidentally deleted an entity member. On re-adding the member I can not find how to re-add the nexel formulas associated with it. This was very easy in the client version.

How do you add nexel formula's at the cell level on the web? I can see the formula I had for other cells but they are greyed out and so is the formula line on the line I need to add. The block the formulas are in is set to deep entity level.




------------------------------
Ian Bradley
VP Finance (CFO)
T&S Brass and Bronze Works, Inc
United States
------------------------------
Tagged:

Answers

  • Ricard Ribatallada
    Ricard Ribatallada Employee
    Fourth Anniversary Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board First Comment
    edited August 2020
    Hi Ian,

    Some of the options are slightly rearranged on the Web Version.

    NEXEL formulae can be updated clicking on the dataview > sliding toolbar, and selecting NEXEL.

    Inside the editor, add a new block (or use the existing one) and select deep rule. Remember to double-click on the cell whose formula you want to edit.

    Please, let me know if you have any further questions.




    image




    editing formula in nexel


    ------------------------------
    Ricard Ribatallada
    Senior Consultant
    Board Community
    United Kingdom
    ------------------------------
    -------------------------------------------
  • Ian Bradley
    Ian Bradley Customer
    Fourth Anniversary 25 Up Votes 5 Likes Name Dropper
    edited August 2020
    I was able to get the nexel formula entered as I was not double clicking. Didn't see that referenced anywhere in the manual or in the elearning.

    The formatting is not consistent with the rest of the block. Do you know how to fix that? ie I have the rest of the block with 2 digits after the decimal but after adding the formula that cell is displaying with zero digits after the decimal


    Thanks for the help

    ------------------------------
    Ian Bradley
    VP Finance (CFO)
    T&S Brass and Bronze Works, Inc
    United States
    ------------------------------
    -------------------------------------------
  • Bettina Clausen
    Bettina Clausen Employee
    Fourth Anniversary 25 Up Votes 25 Likes 5 Answers
    edited August 2020
    Hi Ian,

    to get the decimal digits shown, you can use the block formatting:

    image and set the number of decimals:


    image


    Best regards
    Bettina




    ------------------------------
    Bettina Clausen
    Consultant
    Board
    Germany
    ------------------------------
    -------------------------------------------

Categories