Topic: Using Remainder Function Subscribe | Previous | Next
Siddiqua Mahmud 12/5/2019
Hi,
I posted a message about the sales share of vehicles. Someone told me that use the remainder function along with the growth rate to avoid the error. I tried the same but the error occurred which is shown below in the screenshot of the LEAP.
Kindly help me.
Regards.
.png)
Utsavshree Rajbhandari 2/26/2020
due to growth function in two branches, but only limited in gap (12.8%), the total already becomes more than 100% in very early years.
Please note, growth of vehicle population and growth of share does not imply same thing.
To avoid this, i would recommend to calculate the verticals number explicitly and then convert them to share and instead of growth, use interp function, then you can use remainder function as well, to avoid error that can arise due to tiny decimal numbers.