Hiding tables blocks based on the parameters value

[richard_reeves]

Hello Experts,

I have 8 parameters and 4 table blocks.

I have created 8 variables with (=UserResponse ("Enter Report Sheet1") ,2,3,... 😎

(1) IF all parameters(1,2,3,4,5,6,7,8) has value then show 4th table block and hide rest of the Blocks

(2) If parameters (1, 2 ,3 ,4,5,6) has value then show 3rd table block and hide rest of the blocks

(3) If parameters (1, 2 ,3 ,4) has value then show 2rd table block and hide rest of the blocks

(4) If parameters (1, 2 ) has value then show 1rd table block and hide rest of the blocks

Kindly advice using Isnull with NOT or something. all parameters are optional and user will be putting an input based on above combination.

the formula for (1) on Hide of 4th block as follows

Regards,
R

[former_member615876]

Hi ,

Did you check this link? It looks like It would solve your problem if you are still interested in knowing how to do what you want :

https://answers.sap.com/questions/12741384/hide-table-when-formula-is-true.html

[jyothirmayee_s]

HI,

You can create a single variable using inlist and If-else conditions.

@hideblocks:

=if (UserResponse ("Enter Report Sheet1") inlist ("1","2",.."8") ) then "block1"

else if(UserResponse ("Enter Report Sheet1") inlist("1".."6") ) then "Block2"

Apply filter on each table block depending on the output and make sure to have your tables in relative positions.You can also use Hide when formula true on each table:

for ex: to hide table 1,3,4

=hideblock = "block1"

Thanks,

Jothi