Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a simple table with the program field, the date and the difference in months between the date of each program and the date filtered in the reporting end date. On the other hand I have an inline that returns, depending on the difference in months calculated in the table, its time factor.
I need to take the time factor for each program and I have tried with only ({<N_MONTHS = {$ (vDifDates)}>} N_TIME_FACTOR) and IF but it does not return the Time Factor corresponding to each program.
This is the table that should exit for Reporting End Date without any filtered date (today by default)
PROGRAM | DATE | Dif date | Time Factor |
P1 | 2015-01-01 | 37 | 3 |
P2 | 2015-07-21 | 30 | 3 |
P3 | 2015-12-25 | 25 | 3 |
P4 | 2016-06-18 | 20 | 3 |
P5 | 2017-03-15 | 11 | 2 |
P6 | 2017-04-10 | 10 | 2 |
P7 | 2018-10-31 | -9 | 0 |
P8 | 2018-11-04 | -9 | 0 |
Thank you very much in advance.
Set analysis isn't going to work... but if can...
Sum(If(N_MONTHS = $(vDifDates), N_TIME_FACTOR))
I think you need to use apply map in script
That is not valid because I need the difference between the dates depending on the user selection in filter reporting end date
something like that
I am trying to change 4 as column value but it is giving me error try on your own
=FieldValue('N_TIME_FACTOR',fieldindex('N_MONTHS','4'))
I'm confused about your goal.
Your Island table(having N_MONTHS) and PROGRAM table are not associated in data model so I think it is not possible to Time factor in your current chart. On what basis chart dimensions (PROGRAM,DATE) will link to the values of Time factor/N_MONTHS without any association.
You may need to think of change in data model.
Histalwar1 , Do you think its possible to show columns from un-associated table thru set analysis, could be a new learning for me if its possible.
Set analysis isn't going to work... but if can...
Sum(If(N_MONTHS = $(vDifDates), N_TIME_FACTOR))
That´s perfect !!.Thank you Sunny Talwar
Great!
wow