I am trying to get the churn % calculation for our reports using a custom field churn%.
The current logic is as such:
(Churned users / Users_at_start_of_week ) /100
However, when the field is used in the report, the churn% number seems off.
Pls help.
4 个回答
Vinitha, seems like it's a formula of % type. Please remove * 100 after the formula and make it like
Churned users / Users_at_start_of_week
It will be 2/88 = 2.27%
One follow up question here, how are you expecting 0.05% from row one ?
