https://community.qlik.com/t5/App-Development/Expression/m-p/2518468#M106096 <P>hi there,&nbsp;<BR /><BR />trying to create a measure that calculates:&nbsp;<BR /><BR />=26-If(region = 'CNE', Count(TOTAL &lt;region&gt; overall_score),<BR />36-If(region = 'APAC', Count(TOTAL &lt;region&gt; overall_score),<BR />97-If(region = 'Europe', Sum(TOTAL &lt;region&gt; overall_score))))<BR /><BR />but only CNE calculates ok<BR /><BR />any ideas?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JoseGarcia_0-1747828210886.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/180638i1E1B4ECE5AA43806/image-size/medium?v=v2&amp;px=400" role="button" title="JoseGarcia_0-1747828210886.png" alt="JoseGarcia_0-1747828210886.png" /></span></P><P>&nbsp;</P><P><BR /><BR /></P> Wed, 21 May 2025 11:50:27 GMT JoseGarcia 2025-05-21T11:50:27Z https://community.qlik.com/t5/App-Development/Expression/m-p/2518468#M106096 <P>hi there,&nbsp;<BR /><BR />trying to create a measure that calculates:&nbsp;<BR /><BR />=26-If(region = 'CNE', Count(TOTAL &lt;region&gt; overall_score),<BR />36-If(region = 'APAC', Count(TOTAL &lt;region&gt; overall_score),<BR />97-If(region = 'Europe', Sum(TOTAL &lt;region&gt; overall_score))))<BR /><BR />but only CNE calculates ok<BR /><BR />any ideas?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JoseGarcia_0-1747828210886.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/180638i1E1B4ECE5AA43806/image-size/medium?v=v2&amp;px=400" role="button" title="JoseGarcia_0-1747828210886.png" alt="JoseGarcia_0-1747828210886.png" /></span></P><P>&nbsp;</P><P><BR /><BR /></P> Wed, 21 May 2025 11:50:27 GMT https://community.qlik.com/t5/App-Development/Expression/m-p/2518468#M106096 JoseGarcia 2025-05-21T11:50:27Z https://community.qlik.com/t5/App-Development/Expression/m-p/2518488#M106101 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/113765">@JoseGarcia</a>&nbsp;<BR /><BR />see leaving it as:<BR /><BR />=<BR />If(region = 'CNE',<BR />&nbsp; &nbsp; &nbsp; &nbsp;26-Count(TOTAL &lt;region&gt; overall_score),<BR />If(region = 'APAC',<BR />&nbsp; &nbsp; &nbsp; &nbsp;36- Count(TOTAL &lt;region&gt; overall_score),<BR />If(region = 'Europe',<BR />&nbsp; &nbsp; &nbsp; &nbsp; 97-Sum(TOTAL &lt;region&gt; overall_score)</P><P>)))<BR /><BR /><BR />- Matheus</P> Wed, 21 May 2025 13:10:31 GMT https://community.qlik.com/t5/App-Development/Expression/m-p/2518488#M106101 MatheusC 2025-05-21T13:10:31Z