Blocking Data Entry in Grand Total, while leaving data Open for Subtotals in DataView ?

Akrem ABDELHAFIDH

Hello everyone,

Any tips on blocking data entry for grand total but keeping it open for subtotals in a DataView?

Thanks!

Leone Scaburri

Hello @Akrem ABDELHAFIDH,

did you try with "Totals locked by Block" with type "Column Total"?

Dorra Ben Hmida

Hi @Akrem ABDELHAFIDH ,

I would suggest you to use the "Totals locked by Block" option. It applies the conditional locking either on Row totals or on Column totals of a single Block. When enabled, with every data entry action this option causes a proportional reallocation on the detail cells whose sum is the fixed (locked) total.

For more details, https://www.boardmanual.com/2021/summer/capsules/screens/2_Objects/The_Layout/Layout_Data_Blocks/About_Data_Block_settings.htm?rhsearch=totals%20locked%20by&rhhlterm=total%20totals%20locked%20locking%20lock#dataentry