3 Replies Latest reply: Sep 13, 2018 10:13 PM by Thiago Justen Teixeira RSS

    Synchronize dates of two tables

    Mario Centeno

      Help me.


      I need to synchronize the dates of two different tables, it happens that when I select the date F_IFR it shows me a value but if I select F_UCE it shows me another I want to join the two dates so that the data selection is unique.


      Expression measure

       

      SUM({<[F_IFR.autoCalendar.Year]={'$(vMaxYear)'},

      [F_IFR.autoCalendar.Month]={'$(vMaxMonth)'},[F_IFR.autoCalendar.Day]={'<=$(vMaxDay)'},

      F_IFR=,[F_IFR.autoCalendar.YearMonth]=>}SALES)

      QLK1.png


      qlk2.png