Case 3 – Join series to the same scale

You have probably noticed that the series we’re working with have different scales so simply combining them will not always give the result we were looking for. To have a more smooth junction we need to use one of the following formulas: JoinScaled(series1, series2)  or JoinMoreHistoryScaled(series1, series2)These two versions correspond to cases 1 and 2, respectively.  

Here, we’ve used JoinMoreHistoryScaled(series1, series2), so series2 is scaled so that its value at the date of junction is equal to the value of series1.  

Here’s the result: 

To the see exact construction of the document, you can download the file here.