CHURNAMT function

Returns the amount of churn (value of billings lost due to churn) in given month

Syntax

The CHURNAMT function syntax has the following arguments

  • New_billings_excl_renewals      Required.    Array.    Billings from new customers only; renewal billings, if applicable, are calculated and added automatically; also exclude billings included in other input rows. Default=0; must be a number>=0. By default, Note: this function will return a row of values for the same number of columns that you select for this input. Please make sure that adjacent cells do not have any other content. Add the month_numner input in this function if you need this value for a specific month (and not for all months).

  • Contract_term_#months      Required.    Number.    Contract term (in months); default value=1 (which is month to month); enter 12 for annual subscription, or any other value if term is different; enter 0 if non recurring; must be integer >=0

  • PrePmt_term_#months      Required.    Number.    # months for which customer prepays; default value=1 (which is month to month); enter 12 for annual subscription, or any other value if term is different; enter 0 if non recurring; must be integer >=0

  • Churn_percent      Required.    Number/Array.    Churn % (applied at renewal); default value=0%; must be>=0

  • Are_terms_same_for_renewals      Optional.    TRUE/FALSE (1/0).    Are contract and prepayment terms same for renewals? TRUE=Yes., FALSE=No; default=TRUE

  • Contract_term_#months_renewal      Optional.    Number.    Contract term (in months); default value=1 (which is month to month); enter 12 for annual subscription, or any other value if term is different; enter 0 if non recurring; must be integer >=0

  • PrePmt_term_#months_renewal      Optional.    Number.    # months for which customer prepays for renewals, if different from term at signing; default value=1 (which is month to month); enter 12 for annual subscription, or any other value if term is different; enter 0 if non recurring; must be integer >=0

  • Month_number      Optional.    Number.    Month for which this value is required. Leave this blank (no input) if you need values for the same number of months as the input array. Input value must be integer >=1. For example, enter 6 if you'd like this value for month 6. Note: value will be returned for specified month only if you enter a value.