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
Hey Beck,
Check this out.
Hi Thiago,
thanks a lot for your example, it does make me more sure to find the solution, as you see in app: it was an example, i want to ask you, what would you do (or how would you do) if you have an master calender with years, month to concatenate with field: Finished_On, do you have any idea?
Thanks a lot
Maybe this could be useful on it:
MakeDate(text(left(Time,4),text(right(Time,2)),1)
Obviously, if I understood exactly what you want to.
Hi Thiago,
Thanks a lot for your responce and your valueable time
i try to accomplish my issue and will let you know, when i finished and show the output, ok
Sound's good Beck. I'll be right here if you need again.
Cheers
Thiago, thanks again for your help and your time
Hi Thiago,
i attached my example -app with explanation. Do you have any idea?
Thanks a lot
Beck
Let me see. Just a minute and I'll come back with any suggestion.
Wich extension are you using on it?
Hi Thiago, i dont use any extensions, i wanted to know, is that possible to make the table selectable ( i mean if i create the table with input like aktiv and nonaktive and make the table visible like in my example-app).
Do you have any ideas?
Thanks a lot
Beck