Databases
StackOverflow2013
Postsdbo
POHow do I get the total cost of sales of each item within a loop?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I get the total cost of sales of each item within a loop?
    primarykey
    data
    text
    <p>Within this while loop, there are 4 items that can be picked. Coffee (1), Latte (2), Cappuccino (3), and Espresso (4). The simulation picks a bunch of random numbers in to fill in each customer's order and quantity, and then it calculates the total cost for each customer. Now I have to make a sales report after this while loop and I have to calculate the total amount of sales for each item. How do I do that since the numbers are random and the loop repeats itself depending on the number of customers?</p> <pre><code>while (CustomersSimulated &lt;= MaxCustomersSimulated) { //customer number System.out.println("Customer " + CustomersSimulated); //one random item for each customer Random RandomList = new Random(); int RandomItem = RandomList.nextInt(4) + 1; if (RandomItem == 1) { System.out.println("Item purchased: Coffee"); final double CoffeePrice = 1.50; //random quantity for the item Random RandomListTwo = new Random(); int RandomQuantity = RandomListTwo.nextInt(5) + 1; System.out.println("Quantity purchased: " + RandomQuantity); //total cost for the one customer double TotalCoffeeCost = RandomQuantity * CoffeePrice; System.out.println("Total Cost: $" + NumberFormat.format(TotalCoffeeCost)); } else if (RandomItem == 2) { System.out.println("Item purchased: Latte"); final double LattePrice = 3.50; Random RandomListTwo = new Random(); int RandomQuantity = RandomListTwo.nextInt(5) + 1; System.out.println("Quantity purchased: " + RandomQuantity); double TotalLatteCost = RandomQuantity * LattePrice; System.out.println("Total Cost: $" + NumberFormat.format(TotalLatteCost)); } else if (RandomItem == 3) { System.out.println("Item purchased: Cappuccino"); final double CappuccinoPrice = 3.25; Random RandomListTwo = new Random(); int RandomQuantity = RandomListTwo.nextInt(5) + 1; System.out.println("Quantity purchased: " + RandomQuantity); double TotalCappuccinoCost = RandomQuantity * CappuccinoPrice; System.out.println("Total Cost: $" + NumberFormat.format(TotalCappuccinoCost)); } else if (RandomItem == 4) { System.out.println("Item purchased: Espresso"); final double EspressoPrice = 2.00; Random RandomListTwo = new Random(); int RandomQuantity = RandomListTwo.nextInt(5) + 1; System.out.println("Quantity purchased: " + RandomQuantity); double TotalEspressoCost = RandomQuantity * EspressoPrice; System.out.println("Total Cost: $" + NumberFormat.format(TotalEspressoCost)); } System.out.println(" "); CustomersSimulated++; } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCode-Apprentice
    1. USPandokie
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CO[What have you tried](http://www.whathaveyoutried). (Hint: you probably need several counters.)
      singulars
      1. POHow do I get the total cost of sales of each item within a loop?
      1. USCode-Apprentice
    2. COI tried a for statement within the while loop, but that didn't work out cause I don't know how to add the costs together instead of how many times a customer bought that certain item.
      singulars
      1. POHow do I get the total cost of sales of each item within a loop?
      1. USPandokie
    3. COPlease post the code so that we can help you. If you know, for example, that customers bought 5 lattes, what was the cost for the lattes? How did you calculate that?
      singulars
      1. POHow do I get the total cost of sales of each item within a loop?
      1. USCode-Apprentice
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload