4 Replies Latest reply on Apr 27, 2018 11:01 AM by Deepak Rai

    Extract information from the next row

    Jose Basualdo

      Hi,

      I need to create a formula for the next situation:

       

      I have the next table:

      I need to create a new field (New Task Code) that when the Task Code is "APOW" the new field (New Task Code) give me the next Task Code, but if the Task Code is different to "APOW" the result of the new field (New Task Code) is 0.

       

       

      In Excel I use this formula:

       

       

      However, I do not know how I can find a specific information in Tableau.

       

      Thank you for your help.