Troubleshooting percent change

Data Pipeline

If you are using the Percent Change formula in one of your data pipeline steps, you may notice that if the previous row is 0, the percent change will return NULL.

Percent change

Our data pipeline runs on SQLite which adhere’s to Postel’s Rule. The default behavior when dividing by zero is to return NULL rather than throw an error when dividing by zero. (See SQLite documentation for more information.) This lines up with the generally accepted principle that the concept of percentage change has no meaning essentially when starting from zero.

There are several articles online showing potential workarounds, however, one would be to add an Edit Column step after this step with the following case statement in your custom formula, with “Percent Change” as your column name:

case when “Percent Change” is null then ‘N/A’ else “Percent Change” end

Related Data Pipeline Help Articles

See more