All Forums Database
kunmehta 2 posts Joined 12/13
09 Dec 2013
Teradata

Hi , Recently I come across the similar scenario where I having a source table containing fields Cust_id, Amount , Date. At a single point of time Source table will contain the record for same month.  Now I need a output with the fields Cust_id, date, MTD, YTD. .!!

I am beginner but have to complete this in given deadline. Please help me providing a way to solve this.

M.Saeed Khurram 544 posts Joined 09/12
10 Dec 2013

Hi,
You can find YTD and MTD caiolculation examples here:
http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/App-Performance_SQL_Functions.100.06.html
Please let me know if you need further help.
 

Khurram

You must sign in to leave a comment.