No announcements

### how to calculate the quantity of each item sold?

how to calculate the quantity of each item sold?
| 9 Replies | 7295 Views | Created by w4e - Saturday, April 16, 2011 4:47 AM | Last reply by Mike Feng - Wednesday, April 27, 2011 9:54 AM

### Display total qty sold of each item of each store

In order to generate a table showing the totals of each item been sold at each store, could you ...
| 9 Replies | 1156 Views | Created by dchencm - Friday, June 27, 2014 7:26 PM | Last reply by Visakh16 - Saturday, June 28, 2014 5:35 PM

### Ranking outlet wise quantity sold

sold in 2013] using the following calculated Field formula =CALCULATE([Quantity sold],Calendar[Year]=2013) 3. The ...
| 4 Replies | 1260 Views | Created by Ashish Mathur - Wednesday, May 14, 2014 2:11 AM | Last reply by Ashish Mathur - Thursday, May 15, 2014 5:45 AM

### DAX to compute quantity sold and the last inventory shipped.

to make the subtotals correct: PreviousMnthOn_Hand:= SUMX( VALUES(Dates[Month] ), CALCULATE( [Total On_Hand], PREVIOUSMONTH( Dates[FullDate] ) ...
| 10 Replies | 3723 Views | Created by BIAnalyst - Tuesday, April 9, 2013 3:19 PM | Last reply by BIAnalyst - Wednesday, April 10, 2013 3:30 PM

### How to Calculate quantity from balance quantity

original quamtity, which remains untouched, & a current available quantity, which gets updated each time. Change the computed property to get ...
| 9 Replies | 3806 Views | Created by babloo1436 - Saturday, September 10, 2011 3:00 PM | Last reply by Yann Duran - Sunday, September 11, 2011 9:03 AM

### Ordering sold quantity

;); But this gives an error saying that "You tried to execute a query that does not include the specified expression 'prd_id' as part of an ...
| 6 Replies | 5 Views | Created by Anonymous - Saturday, November 20, 2010 2:41 PM | Last reply by Anonymous - Friday, November 26, 2010 1:27 AM

### How to calculate remaining quantity

Hi Lasha89, I'm not sure if I understand the requirement correctly, because the values in the date column in your sample data appear ...
| 1 Replies | 5056 Views | Created by Lasha89 - Sunday, January 23, 2011 5:20 PM | Last reply by Hugo Kornelis - Monday, January 24, 2011 12:30 AM

### How to calculate total of each item in grid view

User1705988398 posted  Hi all, I use grid view to display items and it's quantity. now i want to get total Qty of ...
| 5 Replies | 1 Views | Created by Anonymous - Friday, September 26, 2008 1:15 AM | Last reply by Anonymous - Monday, September 29, 2008 7:23 AM

### Calculate price for quantity

column, then each product has an price for the size id and quantity at which the price break occurs.   I use this stored ...
| 7 Replies | 5393 Views | Created by Brian Evans - Wednesday, February 20, 2008 5:48 PM | Last reply by Ben Aminnia - Wednesday, February 20, 2008 6:36 PM

### How to deduct sold item from quantity in access database using VB6.0

i am working on my final year project. point of sale. i want the stock to be updated each time an item is sold by deducting sold ...
| 4 Replies | 7336 Views | Created by Favorme - Thursday, February 28, 2013 9:25 AM | Last reply by Renee Culver - Thursday, February 28, 2013 2:21 PM

### Summarizing Item Wise quantity

your report first create a group on Item and then subitem, also in report options enable "Grouping on server" this will speed up  your report. In summary ...
| 1 Replies | 3905 Views | Created by LuxCoder - Friday, August 17, 2007 11:05 AM | Last reply by captJackSparrow - Friday, August 17, 2007 11:43 AM

### Find total quantity of each unique item of a list of items

In your data, I don't know, because I don't understand how it's organized. In the sample code, to get the quantity of each ...
| 2 Replies | 3805 Views | Created by xplorer2k - Monday, February 8, 2010 7:32 PM | Last reply by xplorer2k - Tuesday, February 9, 2010 12:57 AM

### Calculate size of each tabpage

How can I calculate the size of each tabpage. If for example I have 4 tabpages I would like these to be spread accross equally. ...
| 2 Replies | 2782 Views | Created by Scorgi - Wednesday, September 9, 2009 1:24 PM | Last reply by Wole Ogunremi - Wednesday, September 9, 2009 2:09 PM

### How to Calculate Cost Of Goods Sold in Query (LIFO) Method

That is a nasty looking query!!! http://www.obliviousinvestor.com/how-to-calculate-cost-of-goods-sold
| 1 Replies | 4641 Views | Created by Hamad Salahuddin - Monday, January 28, 2013 10:53 AM | Last reply by ryguy72 - Monday, January 28, 2013 9:28 PM

### Calculate inside gridview amount=price*quantity

in next to item dropdown label price. now user insert quantity from next grid textbox and next is label amount shold disply calculate amount on ...
| 1 Replies | 3 Views | Created by Anonymous - Thursday, October 28, 2010 3:57 AM | Last reply by Anonymous - Thursday, October 28, 2010 8:22 AM

### Calculate the sales quantity since the last inventory count?

is no guarantee that every item is inventoried together. Thus the most recent inventory date may refer only to a single item, but we would still count ...
| 10 Replies | 1023 Views | Created by JP3O - Wednesday, September 30, 2015 2:15 PM | Last reply by JP3O - Monday, October 5, 2015 2:09 PM

### How to calculate the number of employees in each month

-31 If we see at the data above Test has 2 rows because he changed his specialty in the middle.My requirement is to calculate the total ...
| 2 Replies | 677 Views | Created by SqlDev12 - Wednesday, June 17, 2015 5:54 PM | Last reply by SqlDev12 - Wednesday, June 17, 2015 7:32 PM

### Calculate a total quantity on update of fields "number of containers" and "quantity per container"

Hi SquirrelMan, you had mentioned that,"I want to update the total quantity of
| 3 Replies | 319 Views | Created by SquirrelMan - Tuesday, July 4, 2017 4:04 PM | Last reply by Deepak Saradkumar Panchal - Wednesday, July 5, 2017 1:43 AM