0 Replies Latest reply: Oct 13, 2015 4:46 AM by youssef belloum RSS

    Intervalmatch to replace the missing dates with a value

      Hi guys, this is my second time here

       

      Please help me find a solution to my problem.

       

      I have a table that contains the following fields:

      sct_part=article

      sct_domain=company

      sct_cst_tot=cost

      sct_sim=year cost

      periode.date=date cost

       

      test.png

      I need to insert the cost for each date of the month, from first to last day, with the value of the cost "sct_cst_tot" that is already inserted.

       

      For example here: there is cost inserted "sct_cst_tot" for the date 09/10/2008, I just want to insert that value "9,555" for all days of the month 10/2008.

       

      I think it is possible with the intervalmatch function,

       

      Thank you.