1 Reply Latest reply: Mar 23, 2018 5:33 AM by Youssef Belloum RSS

    Expression Calculation

    Monu Saraswati

      Hi Team,


      I am trying to do the below calculation:

      (Latest Date Information - Information entered 14 days ago)/Information Entered 14 days ago


      If we do have any data for that date ( "Information entered 14 days ago"), then we need to keep moving a day forward(13th day, 12th day etc) and consider the first available information .


      Please help me in doing the above calculation.