2 Replies Latest reply on Nov 13, 2017 5:11 PM by Paimon Jaberi

    Calculation: Showing a year in a text table based on condition

    Paimon Jaberi

      Hi all,

       

      In table, I would like to show a column which shows the next available year for Inventory. I have two fields. Year and % Available. I just want to show the first year (2017 through 2022) where % Availability is > 0 for the respective inventory item. It could be 2017, could be later and I just want to simply show this year in an existing table.

       

      Seems like a simple calculation, but having trouble. Anyone have an idea of how I can go about tackling this?

       

      Appreciate it!