https://community.qlik.com/t5/QlikView/Only-sum-projects-between-to-values/m-p/1947538#M1219619 <P>Temporarily ignoring all your other rules, I think you may just be looking for this:</P> <P>=sum({&lt;Faktureret={"&gt;=0.01&lt;=<SPAN>100000</SPAN>"}&gt;} Faktureret)</P> Thu, 23 Jun 2022 16:22:08 GMT jwaligora 2022-06-23T16:22:08Z https://community.qlik.com/t5/QlikView/Only-sum-projects-between-to-values/m-p/1946200#M1219579 <P>Hi</P> <P>If I want to change "<STRONG>Faktureret</STRONG>" from being different from "0", to being between to values. For example between 0.01 and 100000 how do i do that?</P> <P>Thanks for the help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>&nbsp;</P> <LI-CODE lang="markup">Sum ( {&lt; Date_num_afsl = {"&lt;=$(=num(floor(MonthEnd(Max(Dato_NUM_Tid))))), &gt;=$(=num(monthstart(Min(Dato_NUM_Tid))))"}, [År Tid] =, [Måned Tid] =, [År (Regnskab) Tid]=, IGVA_DATO =, //Faktureret ={"&lt;&gt;0"} Projektnr = {"*"}-{''}, &gt;} Faktureret)</LI-CODE> <P>&nbsp;</P> Tue, 21 Jun 2022 11:16:36 GMT https://community.qlik.com/t5/QlikView/Only-sum-projects-between-to-values/m-p/1946200#M1219579 Desauv 2022-06-21T11:16:36Z https://community.qlik.com/t5/QlikView/Only-sum-projects-between-to-values/m-p/1947538#M1219619 <P>Temporarily ignoring all your other rules, I think you may just be looking for this:</P> <P>=sum({&lt;Faktureret={"&gt;=0.01&lt;=<SPAN>100000</SPAN>"}&gt;} Faktureret)</P> Thu, 23 Jun 2022 16:22:08 GMT https://community.qlik.com/t5/QlikView/Only-sum-projects-between-to-values/m-p/1947538#M1219619 jwaligora 2022-06-23T16:22:08Z