Surprising I have not been able to find this on the help docs or community, but what is the expression used to calculate the percentage change from the Last Entry to Most Recent Entry in a Column ?
I know the formulation in google sheets is simple ([Current Entry Num]) - [Last Entry Num] / [Last Entry Num] with a percent field.
There is always a problem with the first entry ever because there is no previous value to refer to. In google sheets I wrap it with an IFERROR(formula, 0 which then leaves a 0% value for the first entry. Is there an equivelant expression in AppSheet?
Not sure how to reference these values.
Thanks in advance!