Disabling data entry on totals without disabling the total display

Etienne CAUSSE
Etienne CAUSSE Customer
Fourth Anniversary 250 Up Votes 100 Comments 100 Likes
in Platform

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

Tagged:

Answers

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary
    edited March 2020

    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.

     

    image

    image

     

    image

     

    Regards

     

    Mark

Categories