on 03-24-2015 10:55 AM
Hi experts,
There is a query : in line there are companies'structure and in column there are 35 selection condition include different fs item and Group currency key figure. The need is to change this query , the user want to have the choice between local currency or group currency before execute the query. Do i have to create an other query ( to copy the colums structure and insert Local currency instead of GC) or there is technical solution ?
thanks for your ideas.
S.
I see 3 options:
1. Create a separate query - easy but more maintenance long-term.
2. Create a second structure in the columns with two key figures - local currency and group currency; have one displayed by default and the other one hidden - let the user change the display using filtering;
3. Create a second structure in the columns with 3 key figures: local currency (hidden); group currency (hidden); result - formula using a formula variable ready for input. The user enters a variable value and based on that the formula displays either local or group currency; it is a bit cumbersome but works.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.