Hello fellow community members!
I'm trying to write a formula that will calculate the "Difference" and "Balance Difference" between the current and previous rows "Total Invoice Count" and "Total Balance". The following formulas have worked well on the cell level:
=[Total Invoice Count]@row - [Total Invoice Count]1
=SUM([Total Balance]@row - [Total Balance]1)
I'm able to drop and drag the formulas above to the proceeding rows, but I'd like it to be a column formula instead of a drop and drag. When I select "Convert to Column Formula", I get a notice stating, "The column formula syntax isn't quite right". I've tried numerous combinations without success.
Ideally, the formulas would calculate the "Difference" between the current and previous rows "Total Invoice Count" and the "Balance Difference" between the current and previous rows "Total Balance"; if the current or previous row is blank or zero, leave the cell blank. Any help would be greatly appreciated!
