Hi!

I'm trying to create a graph where I to check the difference between to consecutive periods and identify potential errors.
The idea is that the formula calculates the date difference between the Start Date of the current row minus the End Date of the previous row ( IF (‘Start Date’ – ‘End Date_previous row’) = ‘1’ then ‘Normal’ else ‘Abnormal’)

2019-03-19_Calcs.xlsm - Excel.png


How can I do this with nodes and BrainScript in lavastorm?

Thanks a lot in advance!
Maria