Multi-row for YTD

[sharmilaj]

Hi all,

This is the my data 

DATE	AMOUNT
31/08/2021	100
31/10/2021	500
30/04/2021	300

Using multi row function need to create YTD column and do amount sum from start of the first month. 

Output required 

DATE	AMOUNT	YTD (amount * remaining months in year)
31/08/2021	100	100*4=400
31/10/2021	500	500*2=1000
30/04/2021	300	300*8=2400

kindly help build the flow using multi row function

[caltang]

What is the logic behind YTD * just amount? It doesn't make sense. 

Can you provide some more sample data + explanation? 

[JosephSerpis]

Hi @sharmilaj I mocked up an approach which achieves you desired output however uses datetime functions rather than a multi-row tool.

[flying008]

Hi, @sharmilaj 

Maybe you can try is :

[AMOUNT] * (12- DateTimeMonth(TODATETIME(DateTimeParse([DATE],'%d/%m/%Y'))))

[caltang]

@sharmilaj I see that you’ve included the remaining months of the year as a requirement. I think @flying008 ‘s solution is a more efficient way.