Current and previous day count

[#1]

Hi

Once again I need your help. Please have a look at this small data set in the file attached. I have daily excution results and want to calculate the difference between the current and the previous day.

Or easier, just to get a table that can calculate "Current (execution date)"-"Previous (execution date-1)" and display it in the same row as the current day is.

It shall work simillar to stock calculation, displaying the diff to tomorrow, but my data is organized as it is in the load scrip.

Is there a easy way to do this?

Thank you in advance. Best regards. Lukas

[SunilChauhan · Accepted solution]

in second expression use

=above(Count(ID))

see the attched file

hope this helps

[#3]

Thank you soo much.

Best regards. Lukas