In this example, we're dividing our cancelled subscriptions over our total subscriptions to calculate our churn rate, which is a common SaaS metric.

Create your two layers where you wish to calculate a percentage. This is what my layers look like:

After you've created your two layers, **make sure to use a Cross Join.**

In the Data Pipeline, click +Add Step, then choose Add Column from the dropdown menu. Title your column, then enter the percentage formula, which is as follows:

100.0 * "Column1" / "Column2"

To round your percentage, use the SQLite round() function. Your formula will look like this:

round( 100.0 * "Column1" / Column2", 2)

Where 2 is the number of decimal places.

**If your column values are integers and you would like your results to have decimal precision, be sure to multiply by 100.0. This will convert the top value to a decimal before the division step, and will ensure your results are in decimal form.**

Our example looks as follows:

Click Ok, and your percentages will be calculated.