Lock data entry row total cell only

Harry Sun

Hi BOARD team,

I had a data entry table as following. Can I lock data entry for the row total only (allow data entry at the detailed level, but not the total)?

Can I add a validation based on the TOTAL? When user make data entry at detailed level, the total must be added to 1, otherwise system pop up an alert and does not allow save the data entry. Thanks

Thanks

Helmut Heimann

Hi @Harry Sun ,

there is unfortunately no direct method to achieve that.

You can switch off the row totals for the data entry enabled block and then

• display its values separately in a further block without the detail by and no data entry or
• use the rt(<block>) function to calculate the row total or
• use Nexel to calculate the row total

All of those have a common disadvantage: they will only show the new values after data entry has been saved. Any validation as to their sum needing to be a special value (1 in your case) needs to be performed after data entry, which is not very user-friendly.

You might want to propose an idea regarding that behaviour.

Best,
Helmut