2 Replies Latest reply: Jun 15, 2018 3:45 AM by Алексей Марков RSS

    Count formula for unique values filtered

    Ugur Arslan

      Hi,

       

      I have a aging table.


      Dear all,

       

      I have a aging balance (outstanding amounts) which looks like the following.

       

      Seller IDCar TypeOn HoldCurrentDue 1-30Due 31-60Due 61-90Due 91-120Due 120+
      1456OpalYES$12.00 $-   $345.00 $-   $75.00 $-  
      3478FerdNO$45.00 $-   $566.00 $664.00 $-   $-  
      478382PirscheNO$-   $788.00 $7.00 $6,443.00 $-   $97.00
      48392874OpalNO$-   $9.00 $8.00 $67.00 $7.00 $-  
      247487OpalYES$87.00 $-   $99.00 $8.00 $-   $-  
      47465HundaNO$789.00 $346.00 $6.00 $8.00 $7.00 $-  
      3928094PirscheYES$80.00 $9.00 $54.00 $99.00 $-   $9.00
      278479874OpalNO$-   $8.00 $6.00 $7.00 $89.00 $56.00

       

      The question which I want to answer is:

       

      How many properties with a balance over 90 days due are on hold (YES) and how many not on hold (NO).

       

      The answer should be in a table which has a

      Dimension: ON Hold

      Measure: ?????

       

      Can you please help me, the formulas I try to write give me the wrong answers.

       

      Thanks

       

      Ugur