Disabling data entry on totals without disabling the total display
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
Answers
-
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
0
Categories
- All Categories
- 1.9K Forums
- 1.8K Platform
- 153 Academy
- 314 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 47 How-To Guides
- 19 Board Advocacy Program
- 184 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 335 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP