Hello everyone, I hope you are well.
I am doing an audit application; I have two columns, one called “date” that automatically records the audit date and another called “total result” that records the total sum of the audit result; I need a formula that allows me to compare the “total result” value of the current audit with the “total result” value of the audit with the immediately previous date. I tried it with the formula in the attached image, but it seems to make a comparison between the last record and the one in row one.
Hello, I have no time to develop my answers but you need to select the last date with maxrow where id is different of current I’d.
1 Like
