No announcements

### Calculating YTD Values from financial periods

which can also be used to handle your financial periods hth, gerhard
| 2 Replies | 1089 Views | Created by daveyboyh - Tuesday, February 4, 2014 9:13 PM | Last reply by daveyboyh - Friday, February 14, 2014 5:50 PM

### YTD/PeriodsToDate for Financial Year

Try adding the member from which you wish to sum up to. ie. SUM(PERIODSTODATE( [Date].[Financial Year - Month].[Financial Year],[Date].[Financial ...
| 3 Replies | 871 Views | Created by aivoryuk - Wednesday, October 12, 2016 1:38 PM | Last reply by aivoryuk - Tuesday, October 18, 2016 10:27 AM

### Calculating YTD from store procedure

didnt i gave you solution here?
| 16 Replies | 1709 Views | Created by Evil Poster - Friday, February 21, 2014 11:31 AM | Last reply by Satheesh Variath - Saturday, February 22, 2014 5:35 PM

### Trouble calculating YTD

different syntax.  I've created other calculated measures that work, but this YTD function seems to operate in a different way because it never returns values even though it's ...
| 11 Replies | 8818 Views | Created by Trent Ballew - Monday, November 14, 2005 10:00 PM | Last reply by anish77 - Monday, August 20, 2007 9:17 AM

### Formula to generate financial periods

similar for periods too. We work on a 4,4,5 week cycle (I've been told it's financial but may be wrong) so period 1 is 4 weeks, week no 1-4, period ...
| 4 Replies | 1525 Views | Created by De Dancey - Tuesday, April 16, 2013 2:36 PM | Last reply by De Dancey - Wednesday, April 24, 2013 11:03 AM

### Help needed for calculating YTD values for fiscal years

Hi,      I have some problem calculating YTD values for fiscal years.Our fiscal year starts on sep 1st and ends on 30th aug.I need to ...
| 3 Replies | 4672 Views | Created by krishna.v - Monday, August 16, 2010 1:55 PM | Last reply by Mark Wojciechowicz - Monday, August 16, 2010 8:13 PM

### Calculating Financial Year Figures

Our full financial quarter runs from 1st
| 4 Replies | 3705 Views | Created by Sam233 - Monday, January 11, 2010 10:48 AM | Last reply by Justanewone - Monday, January 11, 2010 12:26 PM

### SSAS - Calculations Current YTD vs Prior YTD Same Periods

-------------------------   [Current Periods]
| 4 Replies | 14801 Views | Created by margni - Monday, August 3, 2009 5:08 PM | Last reply by Raymond-Lee - Wednesday, August 5, 2009 6:21 AM

### calculating values from a database

the query. 1. How to do the code for calculating those 2 values from a databse? 2. How then to incluse the calculated value into the sql query, which the ...
| 1 Replies | 2659 Views | Created by Mitja Bonca - Friday, June 12, 2009 10:43 AM | Last reply by OmegaMan - Friday, June 12, 2009 11:50 AM

### YTD Sales Amount Measure - Calculating wrong field

month so the IF HASONEVALUE check is returning blank so you end up just doing a YTD on the current month values. So you need to adjust your prior month ...
| 5 Replies | 1023 Views | Created by Jeannette_81 - Tuesday, April 24, 2018 4:03 PM | Last reply by Jeannette_81 - Wednesday, April 25, 2018 2:29 PM

### YTD / PeriodsToDate Function with Need to Remove / Filter Periods

What is the ordering of the periods (1-12 vs. 998, 999, 0) in your Time dimension? If the last 3 appear (in that order) at the end of the parent year (presumably in a separate quarter), then ...
| 3 Replies | 4209 Views | Created by ISLAND2010 - Wednesday, March 17, 2010 10:14 PM | Last reply by Deepak Puri - Friday, March 19, 2010 3:40 AM

### Getting null value YTD and Periods To Date Calculation

; {     [Measures].[YTD]    ,[Measures].[Reseller Sales Amount]   } ON ...
| 1 Replies | 5176 Views | Created by Joss83 - Thursday, April 28, 2011 11:38 AM | Last reply by Aniruddha Thengadi - Thursday, April 28, 2011 12:16 PM

### Calculating YTD and Previous Period YTD effectively in the same Pivot

see a section called "calculating many time periods within a single measure formula" which can be used to create dynamic calculations based on the item currently ...
| 3 Replies | 9838 Views | Created by N. Edmonds - Wednesday, February 15, 2012 9:04 PM | Last reply by Javier Guillen - Thursday, March 1, 2012 4:43 AM

### Sum of YTD values for selected month

calculating the sum of YTD values for a given month, e.g. for calculating average inventories over time.To keep it simple, let's assume I have the ...
| 4 Replies | 3533 Views | Created by Mothman3000 - Wednesday, February 29, 2012 2:45 PM | Last reply by Vinuthan - Thursday, March 1, 2012 5:33 PM

### YTD values comming wrong in SSAS

Hello, I am having an issue with the YTD function in Analyis Services. I have a measure Measure1 and a calculated measure Mesaure2 defined as
| 2 Replies | 3366 Views | Created by siaj - Monday, February 23, 2009 2:21 AM | Last reply by siaj - Tuesday, February 24, 2009 12:16 AM

### Trying to get YTD values from a MTD table

Hi, I have a table that has MTD values, I need to get the YTD values from this table in the cube.What I was trying is to get the ...
| 1 Replies | 3810 Views | Created by Name1806 - Monday, August 3, 2009 8:07 PM | Last reply by Raymond-Lee - Wednesday, August 5, 2009 7:46 AM

### Problem with calculating values

no, in num... columns are values from rows of OLTP DB. Problem is that I need for every docID his value of numMetadata, but in fact table docID's are duplicated, and values ...
| 4 Replies | 5765 Views | Created by _Pero_ - Thursday, February 22, 2007 8:23 AM | Last reply by _Pero_ - Friday, February 23, 2007 8:56 AM

### Profit from financial statement

measure is a numeric calculation used in data analysis. It is placed in the Values area when you use a pivot table or PivotChart report to display the financial statement. ...
| 1 Replies | 467 Views | Created by AlexMartini - Thursday, November 3, 2016 9:08 PM | Last reply by Angelia Zhang - Monday, November 7, 2016 7:24 AM