Page 1 of 1

Active form on the Web in conjunction with zero-set suppression

Posted: Thu Nov 30, 2017 10:43 am
by ConPlan
Hello everybody
currently I am creating a planning form with active forms.
I use the zero suppression to not give the user so many lines.
Then I load the form in TM1 Web.
Sometimes it would be useful to show the lines here again.
On the web, I have no button zero suppression as in Excel.
Which options do I have?
Many thanks for your help

Re: Active form on the Web in conjunction with zero-set suppression

Posted: Thu Nov 30, 2017 12:19 pm
by tomok
The TM1RPTVIEW formula has an argument for zero suppression, either 0 or 1. Create a drop-down in cell, with data validation, that accepts either 0 or 1 and point the argument to that cell. User can then select to turn zero suppression on or off with this drop-down.

Re: Active form on the Web in conjunction with zero-set suppression

Posted: Thu Nov 30, 2017 1:22 pm
by ConPlan
Thank you tomok, for the quick and understandable answer.
You helped me a lot. :D