6 Replies Latest reply: Jun 28, 2016 3:10 PM by Aaron Zechman RSS

    How do I get the number of products that is 80% to of total in a Text box

    Aaron Zechman

      All:

       

      I am trying to get the number of items where 80% of the cumulative total displayed in a text box.

       

      An example of this is the following in a table format:

      RankProductAmountCumulative Amount
      1A2626
      2B2551
      3C2475
      4D2398
      5E22120
      6F21141
      7G20161
      8H19180
      9I18198
      10J17215
      11K16231
      12L15246
      13M14260
      14N13273
      15O12285
      16P11296
      17Q10306
      18R9315
      19S8323
      20T7330
      21U6336
      22V5341
      23W4345
      24X3348
      25Y2350
      26Z1351

       

      There are 26 products in this instance.

      80% of 351 is 280.8

      I want to display the number of products not over the cumulative amount inside a text box.  In this case it would be 14.

       

      Any help on this would greatly be appreciated.