0
$\begingroup$

i am using this weighted sum

How to build a function that gives recent years higher weight?

but I am getting values in the range 1- 0.0000002

How can I reduce this range ? Make it something like 1- 0.002 ?

Thanks

1 Answers 1

1

Suppose you are getting $x$ in the range $0.0000002 - 1$. Let $y$ = $((x - 0.0000002) * 0.998 / 0.9999998) + 0.002$. Now $y$ is in the range $0.002 - 1$. So just use $y$ in place of $x$ if you want values in that range.