8 Replies Latest reply on Apr 12, 2018 7:45 AM by Jonas D

    Calculated field based on max date & cost

    Jonas D

      Hi,

       

      Anyone here that can suggest a calculation that will get the text "increase" if the latest date (max date) of each item has the highest cost, else it should show "decrease" as below example

          

       

      if cost in max date is the highest, then "increase", else "decrease"
      itemdatecostincrease/reduction
      A11-12-20172decrease
      A01-01-20184decrease
      A05-02-20181decrease
      B01-02-20174increase
      B03-04-20174increase
      B02-02-20185increase

       

       

       

      Thans in advance