Need help regarding Formula Tool

Lazzanova

Hello dear Alteryx Community members,

I'd like to solve something using the Formula tool. For this I'm using only 3 columns of data:

I've got a list of date_actual, vehicle_id's, and a boolean regarding whether or not a car is stored (in_storage_on_compound)
I need the formula tool (or any other tool that gets the job done) to tell me if a car that is in_storage_on_compound on a given day, was not in_storage_on_compound a day before.

Ex: See row 28. This car is has in_storage_on_compound = 1 on 2021-06-30. And the day before in_storage_on_compound = 0 (2021-06-29)
I need the formula tool to add another column, let's call it storage_inflow, and for line 29 it should give the output of "True" or 1. 

Can anyone help me with this?

With kind regards,

Lazzanova (See attachment of example of data)

Example_Storage_Inflow.csv

Jean-Balteryx

Hi @Lazzanova ,

You can do it using a Multi-Row Formula checking both previous row value and current row value.

Workflow attached ! Tell me if it suits your need or not !

parking.yxmd