Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siewfung
Contributor
Contributor

How to calculate linearity %

hi There,

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

START YREND YRCUSTOMER COMMITTED REVENUE($K)*TOTAL ACTUAL FROM START YR ($K)
20182022$12,784$76
20172022$4,091$50
20192027$37,667$15
20192027$28,956$0
20192027$42,854$8
20192027$38,531$9
1 Reply
vikasmahajan

what will be the formula  ?