Rate Calculation

[tiverson]

I have a statement that I need certain records to multiple the previous value by a rate that is coming from another input

Data

Desired output

[atcodedog05 · Accepted solution]

Hi @tiverson 

Here is how you can do it.

Workflow:

Hope this helps : )

[tiverson]

Thanks, that worked!

[atcodedog05]

Happy to help : ) @tiverson 

Cheers and have a nice day!

[tiverson]

What if I have no entry date assigned for account 2 or 4, but need the same result?

Data