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.
I have an Analytic app that requires one parameter, the current database to extract data from. For example, the user would enter 'A2019' and the wizard will update the input tools accordingly to extract from the A2019 database.
However, in this app I also want to extract from the previous year's database, without having to enter a second parameter. So the user would enter 'A2019' and then some tool would calculate the previous database is 'A2018' and then update another input tool accordingly. All my databases follow the structure A2016, A2017, A2018 etc.
Is this possible? Or do I definitely need a second parameter for the previous database?
The problem is I need this to be dynamic and not hard-coded. So in a few years the user would enter A2021 and it would calculate that A2020 was the previous database.
So it somehow needs to extract the 2021 from the parameter, minus 1, and add the A to it before then updating the Input tool. I may be over-complicating it here but I am trying to minimise parameters required.