Need to generate rows based on a condition

Hi All,
I have a data set below as a sample.

DATE Value Begin Value End Value

1/1 0.0008 211.200 (1+[Value]*[Begin Value]

1/2 0.0008 ? (1+[Value]*[Begin Value]

My 1/2 Begin value should nothing but the End value of 1/1

How do i get the begin value .
Also note begin value will be derived from another source but it should only be updated to the first row of begin value.
Any help on this will be highly appreciated.

Tips and Tricks

Preparation

Accepted answers

nagakavyasri

Use Muti-Row formula tool

Screenshot 2023-06-01 155135.png

End Value.yxmd

All comments

geraldo

@Sameer_Kanade8810

I'm sorry, but with these data that you put, I did not understand your objective.

if you could explain in two more lines it would make my understanding easi

lynnesonney

Hi @Sameer_Kanade8810 !

This looks to me like an interest calculation. The simplest way I could come up with is attached. I generate rows for the dates first, then calculated the beginning balance based on the previous row. From there I can calculated the "END" balance straight across.

Let me know if this helps!

1_6.1.23.yxmd

nagakavyasri

Use Muti-Row formula tool

Screenshot 2023-06-01 155135.png

End Value.yxmd

Sameer_Kanade8810

Thank you all for the help.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335