1 Reply Latest reply: May 22, 2018 3:19 PM by Akshaya Aditya RSS

    Count Distinct in an overdue balance aging

    Ugur Arslan

      Dear all,

       

      please see the table as following:

       

      Aging Bucket
      Company ID1-6061-9090 - 120120+
      Apple$13$50$6
      Peer$8$9$150$50
      Banana$5$9
      PineApple$5
      Bag$7$8$8
      Table$3

       

       

      Dimension = Aging Bucket.

       

      If I want to count how many company ID's have an overdue balance of 90 days I write this expression:

       

      Count({<[Aging Bucket]={'90-120'}+{'120+'}>}distinct [Company ID])

       

      Result = 6

       

      But the result needs to be 4 Companies have an item on 90+.

       

      Can you please help me writing the right expression?

       

      Thanks

       

      Ugur