No announcements

### How to calculate % of each year when there are breakdowns on the rows

Hello. I have row labels and column labels that are years. I want to calculate the % that each row label is of each year. ...
| 2 Replies | 606 Views | Created by AlexMartini - Sunday, September 18, 2016 11:13 AM | Last reply by Angelia Zhang - Monday, September 19, 2016 8:43 AM

### Calculate year over year

Hi Rachel, I need to show both the columns side by side (Current year/week and Last Year/week QTY).
| 4 Replies | 862 Views | Created by Victory5 - Monday, May 20, 2019 11:40 PM | Last reply by Victory5 - Wednesday, May 22, 2019 5:46 PM

### calculate count of rows for each group separately in SQL

]=11353and[DocumentNum]=216and[CalendarYear]=2017 or[ItemRelation]=11511and[DocumentNum]=14and[CalendarYear]=2017 for each group i want ...
| 1 Replies | 559 Views | Created by merzavazeh - Friday, November 23, 2018 9:09 AM | Last reply by Dean Savović - Friday, November 23, 2018 9:22 AM

### how to calculate age from DOB year

Hi Tahir, You are using Patient_Birth_Year which has datatype not as DateTime. Try to run below query and change values, everytime you will get the same ...
| 5 Replies | 2950 Views | Created by Tahir Ayoub - Monday, November 14, 2011 5:36 AM | Last reply by Tahir Ayoub - Monday, November 14, 2011 3:42 PM

### How to calculate Average on Rows

I would create this as a physical measure. (assuming that the count of rows in the fact table is the correct denominator to use for your average) ...
| 5 Replies | 2534 Views | Created by srinivasR - Tuesday, March 13, 2012 1:55 AM | Last reply by srinivasR - Tuesday, March 13, 2012 5:58 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 | 2749 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 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 ...
| 2 Replies | 640 Views | Created by SqlDev12 - Wednesday, June 17, 2015 5:54 PM | Last reply by SqlDev12 - Wednesday, June 17, 2015 7:32 PM

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

it was based on user's selection and calculate how many were sold for each item by the end of each ...
| 9 Replies | 7232 Views | Created by w4e - Saturday, April 16, 2011 4:47 AM | Last reply by Mike Feng - Wednesday, April 27, 2011 9:54 AM

### How to calculate the size of some rows from each table in SQL AZURE database?

Does it help - if you know the size of the Table? Once you have it and assuming each row in a table is of same size - you can do simple arithmetic ...
| 7 Replies | 10951 Views | Created by Jitendra Pancholi - Monday, March 28, 2011 10:59 AM | Last reply by Paras Doshi - Tuesday, April 5, 2011 7:33 AM

### How to insert rows if there are other such rows?

I need to code the INSERT but only if there are such rows already in the table. what is the best way for this?
| 3 Replies | 1497 Views | Created by tusharr - Monday, November 7, 2011 2:11 PM | Last reply by Bob Wu-MT - Tuesday, November 8, 2011 9:19 AM

### Calculate on report, Country on Total year

on the year.  I tried to make a named calculate in the olap cube ( my data source) like ...
| 4 Replies | 1310 Views | Created by DIEGOCTN - Friday, April 19, 2013 9:43 AM | Last reply by DIEGOCTN - Wednesday, April 24, 2013 10:16 AM

### DATEPART to calculate financial year

Hi William  If i read your question correctly you are trying to get the fiscal year that a date lies in. and that you fiscal year ...
| 1 Replies | 1608 Views | Created by William Faulkner2 - Tuesday, September 15, 2015 7:09 AM | Last reply by MichaelAdrianJohnson - Tuesday, September 15, 2015 8:07 AM

### How to Calculate Multiple Rows

>    =IF
| 2 Replies | 3216 Views | Created by Mertoman - Monday, October 29, 2012 10:07 PM | Last reply by Jason Warren - Tuesday, October 30, 2012 12:02 AM

### how to calculate the difference of 2 rows

looking for a custom aggregation.  This can be accomplished through custom report code.  There is a great blog entry on how to do this here:
| 2 Replies | 3206 Views | Created by reddy335 - Tuesday, October 18, 2011 12:43 PM | Last reply by Suhas Kudekar - Tuesday, October 18, 2011 2:10 PM

### how to calculate total no. of rows

;            100%   The logic is :-  i need to count for how many ...
| 8 Replies | 5220 Views | Created by Chaitali Prabhu - Wednesday, April 27, 2011 11:50 AM | Last reply by Norman Gregov - Thursday, April 28, 2011 1:13 PM

### Using calculate to filter by year

need to have a Year column in your table, then we can filter the entire table with condition “[Year]=2014”. Please use the following ...
| 1 Replies | 560 Views | Created by AlexMartini - Tuesday, October 11, 2016 6:00 PM | Last reply by Angelia Zhang - Wednesday, October 12, 2016 12:21 PM

### calculate number of rows - MDX

].[Fiscal].[Month]).Children ,[Measures].[My Measure]))   I can calculate not null values , but if they are = 0 , I still ...
| 2 Replies | 5252 Views | Created by gimsa - Monday, April 21, 2008 6:57 AM | Last reply by gimsa - Wednesday, April 23, 2008 12:12 AM

### Smart LinearAlgorithm --- How to calculate the width of each node?

sibTrans -> Node -> sibTrans -> Node. And I can find this constr to calcaulte the width of each node.
| 7 Replies | 1672 Views | Created by Ke Tian - Saturday, September 28, 2013 1:38 AM | Last reply by Vilmos Foltenyi - Thursday, November 14, 2013 7:07 PM