
1. Re: YTD Calc using DateDiff Function
Shinichiro Murakami Oct 11, 2018 2:23 PM (in response to Ritu Chandiramani)Not exactly sure what is the final expected view, but anyways.
I don't know how July ~ October 2018 are handled when you say "YTD" ??
Thanks,
Shin

2. Re: YTD Calc using DateDiff Function
Ritu Chandiramani Oct 11, 2018 2:54 PM (in response to Shinichiro Murakami)Hello Shin,
Thank you for your prompt response. Please find below the screenshot with the expected result. As shown, YTD_PDAYS along Month of YearMonth is achieved using Table Calculations and YTD_PDAYS_NEW is calculated using DateDiff. You can see that the column from table calculation is summing up values. For Example February 2016 is sum of Patients days in January and February 2016, so on and so forth till Dec 2016 and it restarts at January 2017. This is the expected result. Request you to please let me help me achieve this using DateDiff calculation

3. Re: YTD Calc using DateDiff Function
Shinichiro Murakami Oct 11, 2018 2:57 PM (in response to Ritu Chandiramani)Why you need to use datediff?
Shin

4. Re: YTD Calc using DateDiff Function
Ritu Chandiramani Oct 11, 2018 3:44 PM (in response to Shinichiro Murakami)I need to use these YTD calculated values in LOD calculations. As I have used table calculations in YTD_PDAYS along Month of YEARMONTH, I am not able to use that field in LOD calculations. That is why I am trying DateDiff approach

5. Re: YTD Calc using DateDiff Function
Shinichiro Murakami Oct 11, 2018 3:55 PM (in response to Ritu Chandiramani)I am still not sure why you need to specify the method.
To get expected result, add year(YEARMONTH)
And running sums restarting every year..
Thanks,
Shin

6. Re: YTD Calc using DateDiff Function
Ritu Chandiramani Oct 11, 2018 4:02 PM (in response to Shinichiro Murakami)Hello Shin,
As previously mentioned, I cannot use Table Calculations since I have to use the results from this calculation in LOD calculations

7. Re: YTD Calc using DateDiff Function
Shinichiro Murakami Oct 11, 2018 4:17 PM (in response to Ritu Chandiramani)1 of 1 people found this helpful 
8. Re: YTD Calc using DateDiff Function
Ritu Chandiramani Oct 12, 2018 6:45 AM (in response to Shinichiro Murakami)Thank you Shin! This method has helped me calculate the Patient Days Accurately.
Now when I use the same formula to calculate Membership, I do not get the correct values (See below screenshot). MEMB is the Monthly value for Baldwin Park, YTD_MEMB along Table is calculating the YTD Membership using Table Calculation and YTD_MEMB_NEW is using the calculation you suggested.
The reason it is showing such big numbers for Membership with the new formula is because in the filtered dataset I get 105 rows with 253,624 as the MEMB count. So it adds up all 105 rows. Is there a way I can tweak the formula to match the results from the Table Calculation

9. Re: YTD Calc using DateDiff Function
Shinichiro Murakami Oct 12, 2018 7:41 AM (in response to Ritu Chandiramani)Please attach your workbook.
Shin

10. Re: YTD Calc using DateDiff Function
Ritu Chandiramani Oct 12, 2018 10:49 AM (in response to Shinichiro Murakami)Hello Shin,
It doesn't let me attach my workbook again in this response. Do you have my Original Workbook?
Best Regards,
Ritu Chandiramani

11. Re: YTD Calc using DateDiff Function
Shinichiro Murakami Oct 12, 2018 1:05 PM (in response to Ritu Chandiramani)I am just lazy to try recreate your formula.
I have original but receiving from you is much easier.
You cannot attach file from inbox.
Shin

12. Re: YTD Calc using DateDiff Function
Shinichiro Murakami Oct 13, 2018 3:50 PM (in response to Shinichiro Murakami)1 of 1 people found this helpful 
13. Re: YTD Calc using DateDiff Function
Shinichiro Murakami Oct 15, 2018 2:46 PM (in response to Shinichiro Murakami)If this meets your requirement, please mark my answer as correct to close the thread.
Not from inbox, but from original post.
Thanks,
Shin

14. Re: YTD Calc using DateDiff Function
Ritu Chandiramani Oct 17, 2018 2:35 PM (in response to Shinichiro Murakami)Hello Shin,
I have gone and marked your answer as correct on the forum. Thank you for
your help!
I have a new issue with calculating Membership. May I send you the workbook
over email with problem explanation so that you can help me?
Or do you want me to post it on the Forum?
Best Regards,
Ritu Chandiramani
On Mon, Oct 15, 2018, 18:24 Shinichiro Murakami <