9 Replies Latest reply: Feb 20, 2018 1:42 PM by Jahanzeb Hashmi RSS

    Return field from one calculated in chart

    Fernanda Gomez

      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 sh
      ould exit for Reporting End Date without any filtered date (today by default)

      PROGRAMDATEDif dateTime Factor
      P12015-01-01373
      P22015-07-21303
      P32015-12-25253
      P42016-06-18203
      P52017-03-15112
      P62017-04-10102
      P72018-10-31-90
      P82018-11-04-90




      Thank you very much in advance.