1 Reply Latest reply on Oct 18, 2018 9:09 PM by Shinichiro Murakami

    % Churn by age does not work

    Alexander Farr

      Hello everybody,


      I want to display the percentage of customers that have indicated that they want to churn (Churn=1, 0 otherwise) the contract compared to all customers of their age group. I have used following formula:




      However, this yields following:



      Why is my formula wrong?


      In the same (attached) workbook I have created following visualization:



      How can I add a label for the null values?


      I really appreciate your help.

      Thank you!