This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You can connect multiple Action tools to the same In-DB Filter. However, the problem here is that each update Action is taking place in a separate transaction, so the second Action negates the changes made by the first.
I recommend you input both dropdown values to a single Action tool to make both changes with one Action tool by constructing a new filter string using the two values.
Here's an example If the year dropdown is the #1 connection to the Action tool, and the #2 connection is the dropdown for the period. The Action should be set to "Update with Formula".
'And "0FISCYEAR" = '+tostring([#1])+' And "0FISCPER3" = '+tostring([#2])