https://community.qlik.com/t5/App-Development/How-to-calculate-linearity/m-p/1562182#M40953 <P>hi There,</P><P>Based on the data below, how to create linearity %?</P><TABLE><TBODY><TR><TD>START YR</TD><TD>END YR</TD><TD>CUSTOMER COMMITTED REVENUE($K)</TD><TD>*TOTAL ACTUAL FROM START YR ($K)</TD></TR><TR><TD>2018</TD><TD>2022</TD><TD>$12,784</TD><TD>$76</TD></TR><TR><TD>2017</TD><TD>2022</TD><TD>$4,091</TD><TD>$50</TD></TR><TR><TD>2019</TD><TD>2027</TD><TD>$37,667</TD><TD>$15</TD></TR><TR><TD>2019</TD><TD>2027</TD><TD>$28,956</TD><TD>$0</TD></TR><TR><TD>2019</TD><TD>2027</TD><TD>$42,854</TD><TD>$8</TD></TR><TR><TD>2019</TD><TD>2027</TD><TD>$38,531</TD><TD>$9</TD></TR></TBODY></TABLE> Thu, 28 Mar 2019 04:26:41 GMT siewfung 2019-03-28T04:26:41Z https://community.qlik.com/t5/App-Development/How-to-calculate-linearity/m-p/1562182#M40953 <P>hi There,</P><P>Based on the data below, how to create linearity %?</P><TABLE><TBODY><TR><TD>START YR</TD><TD>END YR</TD><TD>CUSTOMER COMMITTED REVENUE($K)</TD><TD>*TOTAL ACTUAL FROM START YR ($K)</TD></TR><TR><TD>2018</TD><TD>2022</TD><TD>$12,784</TD><TD>$76</TD></TR><TR><TD>2017</TD><TD>2022</TD><TD>$4,091</TD><TD>$50</TD></TR><TR><TD>2019</TD><TD>2027</TD><TD>$37,667</TD><TD>$15</TD></TR><TR><TD>2019</TD><TD>2027</TD><TD>$28,956</TD><TD>$0</TD></TR><TR><TD>2019</TD><TD>2027</TD><TD>$42,854</TD><TD>$8</TD></TR><TR><TD>2019</TD><TD>2027</TD><TD>$38,531</TD><TD>$9</TD></TR></TBODY></TABLE> Thu, 28 Mar 2019 04:26:41 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-linearity/m-p/1562182#M40953 siewfung 2019-03-28T04:26:41Z https://community.qlik.com/t5/App-Development/How-to-calculate-linearity/m-p/1562341#M40963 <P>what will be the formula&nbsp; ?</P> Thu, 28 Mar 2019 10:11:02 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-linearity/m-p/1562341#M40963 vikasmahajan 2019-03-28T10:11:02Z