How to calculate linearity % - Qlik Community

siewfung · ‎2019-03-28

hi There,

Based on the data below, how to create linearity %?

START YR	END YR	CUSTOMER COMMITTED REVENUE($K)	*TOTAL ACTUAL FROM START YR ($K)
2018	2022	$12,784	$76
2017	2022	$4,091	$50
2019	2027	$37,667	$15
2019	2027	$28,956	$0
2019	2027	$42,854	$8
2019	2027	$38,531	$9

vikasmahajan · ‎2019-03-28

what will be the formula ?

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.