No announcements

### Quantity * LAST known price

Hi Amit, Why don't you use calculated column with the DAX formula =[price]*[quantity] ?
| 5 Replies | 989 Views | Created by עמיתת - Thursday, February 19, 2015 9:08 PM | Last reply by Charlie Liao - Monday, February 23, 2015 7:04 AM

### Merging 2 queries to create a Quantity * LAST KNOWN price calculation

you can use this formula to calculate the last known price Last Valid ...
| 3 Replies | 913 Views | Created by עמיתת - Friday, February 20, 2015 6:26 PM | Last reply by עמיתת - Sunday, March 22, 2015 8:15 AM

### Calculate price for quantity

lower unit price and therefore, it looks for MIN(Price).  My approach doesn’t have that assumption and just looks for the price of highest quantity not ...
| 7 Replies | 5367 Views | Created by Brian Evans - Wednesday, February 20, 2008 5:48 PM | Last reply by Ben Aminnia - Wednesday, February 20, 2008 6:36 PM

### Price Based on Quantity

] , [Quantity] , [Price] from Prices where ListId = @ListId and ProductID = @ProductId and SizeId = @SizeId and Quantity
| 9 Replies | 635 Views | Created by 2012S4 - Tuesday, January 19, 2016 6:57 PM | Last reply by Eric__Zhang - Wednesday, January 20, 2016 2:46 AM

### MDX - Calculate at lowest grain before rollup Problem

],[SKU - Brand - Known].[In Catalog].[All],[SKU - Brand - Known].[Call For Price].[All] ,[Current Customer].[National Account].[All],[Current Customer].[Group ...
| 2 Replies | 2446 Views | Created by Michael Simon - Business Intelligence - Tuesday, September 10, 2013 2:48 PM | Last reply by Elvis Long - Friday, September 13, 2013 6:38 AM

### How to count quantity with Price = 0?

Invnetory Name Quantity Price Amount
| 6 Replies | 1669 Views | Created by CUONGIT - Tuesday, October 8, 2013 4:39 AM | Last reply by Elvis Long - Thursday, October 10, 2013 10:49 AM

### Finding last purchase price

Hi,  I need to find the last purchase price for each product.  If I run the following code, I correctly get 1 result for each productID and the last purchase order ...
| 10 Replies | 2216 Views | Created by Philm778 - Tuesday, September 29, 2015 7:02 PM | Last reply by --CELKO-- - Wednesday, September 30, 2015 2:08 AM

### How to sum quantity with Price = 0\$ in MDX?

Hi CUONGIT, The duplicate case for this issue:
| 3 Replies | 1057 Views | Created by CUONGIT - Tuesday, October 8, 2013 8:00 AM | Last reply by Elvis Long - Friday, October 11, 2013 1:27 AM

### Last GPS known location

Hi, Is there a way to get last GPS location of the device ? I can have new location if mobile moves thanks to the GeoCoordinate watcher, but if not how can I get its last GPS ...
| 5 Replies | 2717 Views | Created by Xavier André IMM - Thursday, December 9, 2010 5:31 PM | Last reply by - Friday, June 5, 2015 12:41 AM

### How to sum quantity with Price = 0\$ in MDX?

Hello , So if you want your measure to function as summing the quantity for price = 0, you need to define a new measure in your cube (calculation tab) that will ...
| 3 Replies | 1097 Views | Created by CUONGIT - Wednesday, October 9, 2013 7:20 AM | Last reply by David Harazi - Thursday, October 10, 2013 11:55 AM

### Last Known Position

mechanisms to get location (such as wifi, etc) IIRC. Another hacky option could be for you to always store the last location that was used in the app, and start with that ...
| 2 Replies | 15 Views | Created by Anonymous - Wednesday, August 27, 2014 8:00 PM | Last reply by Anonymous - Wednesday, August 27, 2014 8:32 PM

### Calculating price * quantity to get tax results in 0.00

Hi, The formatcurrency function return a string value with a decimal symbol. In your case, the FormatCurrency function returns the result of the calculation '((price * ...
| 2 Replies | 3827 Views | Created by programmer4life - Sunday, October 15, 2006 4:34 AM | Last reply by programmer4life - Sunday, October 15, 2006 4:16 PM

### select last time quantity starts increasing

Mangal, That works with the sample data provided, but not if you expand the example.  The OP was looking for the last date when the quantity starts ...
| 5 Replies | 3498 Views | Created by eliewadi - Wednesday, February 18, 2009 12:31 AM | Last reply by - Wednesday, February 18, 2009 8:55 AM

### Bringing the last price in model separately

]=Table2[Last Date] )) LastPrice = CALCULATE(max(Table2[Invoice Price
| 2 Replies | 580 Views | Created by hysenlici - Sunday, August 6, 2017 1:20 AM | Last reply by willson yuan - Monday, August 7, 2017 6:47 AM

### MDX code help last known value

What is suggested is to create a measure [Last DRE Cnt] with LastNonEmpty as the AggregationFunction. You already have a [DRE Cnt] measure with SUM. The SCOPE ...
| 6 Replies | 4582 Views | Created by jsnmk - Wednesday, November 3, 2010 7:32 PM | Last reply by Naveen Das - Thursday, November 4, 2010 1:22 PM

### How to sort quantity and without quantity ?

Price,Quantity)           FROM @Products
| 12 Replies | 3728 Views | Created by Alex Q8 - Tuesday, January 13, 2009 8:12 AM | Last reply by Alex Q8 - Tuesday, January 13, 2009 10:15 AM

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

the current date in a single-date pivot table row, or the last date of a span of time e.g. a month from a pivot table row). This is the ...
| 10 Replies | 982 Views | Created by JP3O - Wednesday, September 30, 2015 2:15 PM | Last reply by JP3O - Monday, October 5, 2015 2:09 PM

### ASP.NET GridView How to multiply quantity to price and show the total in the amount cell

I have webform which have a GridView. There are quantity, price and amount field.
| 1 Replies | 1221 Views | Created by hasnain_ahmad - Friday, March 6, 2015 11:46 AM | Last reply by Pengzhen Song - Wednesday, March 11, 2015 7:51 AM

### sql query, rank, no price change last 5 years

--"...a way to figure partIds for which the price did not increase in the last 5 years. " create table test (sentdate datetime, price decimal
| 4 Replies | 539 Views | Created by metallon123 - Monday, February 11, 2019 8:09 PM | Last reply by Jingyang Li - Tuesday, February 12, 2019 7:04 PM

### Create pivot in sql where price multiply for last months

','31.01.2019',212.52), (x,y,'01.02.2019','NULL',225.27); but only on last date. Last date in price is where ...
| 2 Replies | 370 Views | Created by Jury Wox - Tuesday, March 19, 2019 12:32 PM | Last reply by Will_Kong - Wednesday, March 20, 2019 6:59 AM
• Items 1 to 20 of 324331 Next ›
No announcements