No announcements

### Calculating YTD Values from financial periods

which can also be used to handle your financial periods hth, gerhard
| 2 Replies | 1094 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 | 915 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 | 1722 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 | 8823 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 | 1537 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 | 4681 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 | 3716 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 | 14927 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 textboxes

can only use onblur if that is the only usable element on the page. The OP never told us where the values in the amount due TextBox come ...
| 26 Replies | 32 Views | Created by Anonymous - Wednesday, February 4, 2009 7:24 AM | Last reply by Anonymous - Wednesday, February 11, 2009 3:44 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 | 1153 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 | 4213 Views | Created by ISLAND2010 - Wednesday, March 17, 2010 10:14 PM | Last reply by Deepak Puri - Friday, March 19, 2010 3:40 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 | 2665 Views | Created by Mitja Bonca - Friday, June 12, 2009 10:43 AM | Last reply by OmegaMan - Friday, June 12, 2009 11:50 AM

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

; {     [Measures].[YTD]    ,[Measures].[Reseller Sales Amount]   } ON ...
| 1 Replies | 5189 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 | 9907 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 | 3551 Views | Created by Mothman3000 - Wednesday, February 29, 2012 2:45 PM | Last reply by Vinuthan - Thursday, March 1, 2012 5:33 PM

### YTD, YTD change vs previous YTD on TIME DIMENSION

Hi!! I need some help. I don't know if I can define in time dimension an attribute that gives me YTD values, YTD growth for any measure... Which steps i need to ...
| 1 Replies | 5130 Views | Created by xgutierrez - Wednesday, March 17, 2010 4:50 PM | Last reply by xgutierrez - Wednesday, March 17, 2010 5:00 PM

### Is decimal used exclusively in calculating financial numbers these days?

User-858993849 posted Googling 'decimal vs money vs float" for financial applications comes back to always use decimal at the cost of performance of its accuracy. ...
| 2 Replies | 2 Views | Created by Anonymous - Saturday, February 25, 2017 12:39 PM | Last reply by Anonymous - Saturday, February 25, 2017 1:22 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 | 3376 Views | Created by siaj - Monday, February 23, 2009 2:21 AM | Last reply by siaj - Tuesday, February 24, 2009 12:16 AM