Keypup

Type: Function Function: <code>IF_ZERO</code>

Syntax: <code>IF_ZERO(value, fallback_if_zero)</code>

Description: Returns the first value or the second value (fallback) if the first one is equal to <code>0</code>. The value and its fallback must have the same type.

<code>IF_ZERO(lines_changed, 1)</code> returns <code>1</code> instead of <code>lines_changed</code> if the latter is equal to zero. This operator is particularly useful when doing divisions.

<code>SUM(deletions)/SUM(IF_ZERO(additions, 1))*100</code> returns a refactoring ratio (percentage) and handles the case where no lines were added (<code>additions = 0</code>).

- <code>IF_ZERO(lines_changed, 1)</code> returns <code>1</code> instead of <code>lines_changed</code> if the latter is equal to zero. This operator is particularly useful when doing divisions.
- <code>SUM(deletions)/SUM(IF_ZERO(additions, 1))*100</code> returns a refactoring ratio (percentage) and handles the case where no lines were added (<code>additions = 0</code>).

IF_ZERO

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you