Previous row with Multi row formula

[slckkrky]

Hello everyone

I am trying to get a value from previous value without any other condition however the Multi row formula doesnot work as i needed.

Could you help me with why that is happening?

Thank you in advance

 

 

[caltang · Accepted solution]

Works fine for me:

[PhilipMannering]

Try doing this after a Summarize Tool groupby on [Reporting Date]. You can always join it back on to your original dataset afterwards. 

[slckkrky]

oh it is working as well. I ticked group by within multi row tool and thats why it wasnot working properly. Thank you