3 Replies Latest reply on Jun 25, 2018 12:56 PM by Deborah Auer

    Looking for formula equilevant to excel formula

    Deborah Auer

      Please help me find the Tableau equivalent formulas to ones I have in Excel for Open field and the Closed field.

      They are highlighted in yellow in the Matrix tab.  The data (same as Tableau fields) is in the data tab.

       

      I am trying to get the remaining open NCRs that were opened within each previous report period.

      and the remaining closed NCRs that were opened within each previous report period.

       

      example:

      There were 39 NCRs opened in October 2016.  Of those 39, 9 are currently Open and 30 are currently Closed.

       

      see excel attached.