Call (+1) 650-212-1212


How to limit entry to specific cells of an edit table

Lonnie Chrisman 20 Jun 2018

Netflix's basic subscription plan was introduced in May 2014. In a Netflix business model that I created, I have an edit table where I can enter the number of subscribers of each plan time in each month. 

Edit table with some cells greyed out

Since the Basic Subscription didn't exist prior to May 2014, it doesn't make sense to allow entry of data into the cells for Basic in April 2014 or earlier. So I've configured the table to allow entry only in the cells where a number is sensible. The other cells are grayed out and won't allow you to enter a number.

This short video shows how it is done using a SubTable. It is as easy as SubTable( If is_active Then Number_subscribers Else null ). Watch this short video to see the details.

(or Watch directly on YouTube)

Analytica 5 Video Shorts are short videos on a single topic, under 5 minutes in Analytica 5. 

Please remember to subscribe to one of Lumina's social media channels (LinkedIn, Twitter, Facebook) so you'll know when new content becomes available.

» Back

Lonnie Chrisman

Lonnie Chrisman, PhD, is Lumina's Chief Technical Officer, where he heads engineering and development of Analytica®. He has authored dozens refereed publications in the areas of machine learning, Artificial Intelligence planning, robotics, probabilistic inference, Bayesian networks, and computational biology. He was was in eighth grade when he had his first paid programming job. He was awarded the Alton B. Zerby award "Most outstanding Electrical Engineering Student in the USA", 1987. He has a PhD in Artificial Intelligence and Computer Science from Carnegie Mellon University; and a BS in Electrical Engineering from University of California at Berkeley. Lonnie used Analytica for seismic structural analysis of an extension that he built to his own home where he lives with his wife and raised four daughters: So, he really trusts Analytica calculations!

Leave a Comment