Hi,
I have a input file which is having two date fields,I want to know how to get the quarter if date is blank and also want to do quarter wise calculation
Input Data is like this
Start Date | End Date | Value |
11/10/2013 | Blank | 10 |
1/1/2014 | 2/4/2014 | 20 |
Output Should be Quarter wise Data for Start Date when End Date is blank
Output Should be
Start Date Year | 2013 |
Start Quarter | Q4 |
Value | 10 |
Want to do the Quarter wise sum based on two dates.
Input File:
Start Date | End Date | Value |
11/10/2013 | Blank | 10 |
1/1/2014 | 2/4/2014 | 20 |
11/10/2013 | 1/1/2014 | 10 |
Output should be
Year | 2013 | 2014 |
Quarter | Q4 | Q1 |
Value | 20 | 30 |
Please help me in solving this scenario.