NEXEL on Web

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
------------------------------

Find more posts tagged with

Configure

Accepted answers

All comments

Ricard Ribatallada

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.

------------------------------
Ricard Ribatallada
Senior Consultant
Board Community
United Kingdom
------------------------------
-------------------------------------------

Ian Bradley

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

Hi Ian,

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

and set the number of decimals:

Best regards
Bettina

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