HOW TO CALCULATE RATE OF INCREASE

[ajisafeadeoye]

Hi KNIMERS, please how do i create the rate of increase for this Data

i was able to generate column B,C,D. The “increase Rate” Column was generated by this method
(B3-B2)/B2 MULTIPLY BY 100

i would appreciate the solution

Thanks

[ajisafeadeoye]

i mean, i need the node to calculate column D

Thanks

[rfeigel]

Use Lag Column and then Math Formula nodes. In the future, please attach data, so someone trying to help you doesn’t have to type it in.

Calculate Rate of Increase – rfeigel

[ajisafeadeoye]

worldwide-aggregate_csv.csv (33.2 KB)

attached is the document , i could not get the solution

[ajisafeadeoye]

worldwide-aggregate_csv.csv (33.2 KB)

i did not get the solution, attached is the document, can you explain further

[rfeigel]

What’s the exact problem you’re having?

[rfeigel]

Here’s the workflow with your data.

Calculate Rate of Increase – rfeigel

[ajisafeadeoye]

The formula not giving the right result

[Daniel_Weikert]

seems like you are lacking paranthesis “(”
(x-y) / y
br

[ajisafeadeoye]

Thank you

Correct now

[ajisafeadeoye]

Thank you

now solved

[rfeigel]

@ajisafeadeoye I had no idea what your workflow looks like. I provided you with a simple example to show you how to use the Lag Column node. @Daniel_Weikert is right.