This content has been marked as final.
Show 2 replies
-
1. Re: Calculating Difference between most recent and least recent values
Michael Someck Apr 17, 2017 2:37 PM (in response to Vijaya Kumar Reddy Chinnam)2 of 2 people found this helpfulHi Vijaya,
I'm using v10.2 so can't attach a workbook, but I slightly changed the formulas for Most and Least Recent Rate. If you use:
Most Recent Rate
{FIXED [Code] : sum(if [Most Recent Date]=[Effective Date] then [Rate] END)}
and
Least Recent Rate
{FIXED [Code] : sum( if [Effective Date]=[Least Recent Date] then [Rate] END)}
That should get you what you're looking for.
Let me know if that helps
Michael
EDIT: I realized an error in the formulas. Should be fixed now!
-
2. Re: Calculating Difference between most recent and least recent values
Vijaya Kumar Reddy Chinnam Apr 24, 2017 3:38 AM (in response to Michael Someck)Thanks Michael !!! This solution works for me.