1 Reply Latest reply on Apr 1, 2013 10:17 AM by philmodjunk

    Distribution Frequency

    PaulChan

      Title

      Distribution Frequency

      Post

           HI All,

           I am really stuck for the past week trying to figure this out and I hope someone is able to shed some light please.

           I've grouped people via a sort by Last Name.  It would give me the total QTY of records related to the person.  Based on the QTY, I was able to assign a BIN to a range.  Say that the total QTY is 15 and the BIN would be 1000:

           Bin=

           If (GetSummaryBINTotalQty <= 1000; 1000;

           If (GetSummaryBINTotalQty <= 2000; 2000;

           If (GetSummaryBINTotalQty <= 3000; 3000;

           If (GetSummaryBINTotalQty <= 4000; 4000;

           If (GetSummaryBINTotalQty <= 5000; 5000; "5000+")))))

            

           This portion works.  Now what I want to accomplish next is to count once only the Bin value for each group found like:

           Person A: 1000

           Person B: 2000

           Person C: 1000

           Person D: 1000

           Person E: 5000

            

           Bin1000= 3

           Bin2000= 1

           Bin3000= 0

           Bin4000= 0

           Bin5000= 1

            

           What is currently happening is that it is counting the BIN value of each record.  What do I need to do please.