12 Replies Latest reply: Jul 7, 2017 7:29 AM by Sébastien Fatoux RSS

    Above and below function

    dada khalander

      Hi,

       

      I have data like below.

      I have used Above function but values is coming NULL.

      Datesecond DateSalesCalcu
      1/26/2016-20002000
      2/1/20162/1/2016-
      2/13/2016-50005000

       

      wherever date is equal to second date i want to apply below condition and i want to show that in calcu.

       

      above(sales)+((Below(sales)-Above(sales))*(secondate-date))/(Below(date)-Above(date))

       

      but values is coming nulls for the above calculation

      Please do the needful