Could someone please advise me how do use a simple "if - then - else" construct to take two columns of population data on different dates and compute a new column of the percentage change? I also need to account for potential divide-by-zero errors. I have tried writing straightforward if field1 > 0 then (field2 - field1)/field1 else 0 end if (done both with and without the end if) but of course this fails. I tried using the example code from one of the knowledgebase articles: Static lastValue as variant Dim Output As Double If IsEmpty(lastValue) Then Output = 0 Else Output = (([Increment] - lastValue) / lastValue) * 100 End If lastValue = [Increment] but this, too fails. I had even created a field containing the "increment" (but named differently), but with no success. And of course the compiler gives absolutely no idea of what might be wrong. This should NOT be that hard. What am I doing wrong?
... View more