Disabling data entry on totals without disabling the total display

Etienne CAUSSE

Hi all,

Everything is in the title: I'm looking for a way to disable data entry on a total without removing the total itself.
The dataview is a basic table to enter data at the physical cube level (no use of split & splat), and we would like to display the total of 3 lines without letting the user modify the total directly (as this would make no business sense in the process).

 

An idea anyone ?

 

Thanks,

Etienne

Previous Member

Hi,

 

i think you can solve this problem by adding two blocks to your layout:

 

- one algorithm containing a 1 for each cell

- and one locking algorithm with if(x=1,01).

- using the locking functionality on the latter

 

This way you do not lock your lines since they will allways have the value 1 and your totals will be locked if you have more than one line.

 

 

 

Regards

 

Mark