Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i goit a following situation, my table does look like:
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
C | 31.11.2017 | CC | 30 |
D | 31.09.2017 | CC | 60 |
and i use as timefilter, that i created on base of master calender the following filter:
Timefilter |
2017 11 |
2017 10 |
2017 09 |
2017 08 |
and i use the following set expression to calculate the budget for every typ of project:
Budget: | |
Sum({<Typ = {'AA'}>}Budget) | 100 |
Sum({<Typ = {'BB'}>}Budget) | 150 |
Sum({<Typ = {'CC'}>}Budget) | 90 |
everything does work great, now i have a question: lets imagine, my reportdate is:
2017 11 and if i select the date in Timefilter: 2017 11 , then should appear only two project:
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
because my timefilter-date: 2017 11 is lower then 01.01.2018 and 31.12.2017
and if select as reporting date 2017 10 then shoudl appear the following projects:
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
C | 31.11.2017 | CC | 30 |
because my timefilter-date: 2017 10 is lower then 01.01.2018, 31.12.2017 and 31.11.2017
Does have anybody any idea how to handle dynamic this issue with the helps of set expression?
Thanks a lot
Beck
Yes, it is possible.
I'm preparing something with it.
I would be grateful for any ideas or suggestions
Check this app. Please, install the extension to see full customization aplied.
Add this expression for the table's title. It's gonna be more dinamical and atractive:
=GetFieldSelections(Projekte) & ' Projects'
If you want to talk more about this thread in particular, you can add me on Skype: justen.thiago.
Hi Thiago,
thanks a lot for your help and time, i am not able to open the extension, i am now at home und will try to open tomorrow in the office, and will immediately report when i have any results. ok
That's ok Beck. Here is a snapshot, just to you figure it out what you'll find into the app.
Thiago,
thanks a lot for your help and your time, i will definitely inform tomorrow about my results.
Thanks a lot
Hi Thiago,
good morning. Thiago i am not able to open your extension. do you have the zip-file for your extension?