https://community.qlik.com/t5/Management-Governance/Negative-Amount/m-p/2032485#M24227 <P>I have payment amount in negative and decimal also. How to check less than 0 and greater than 0 amount?<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="amount1.PNG" style="width: 815px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99370iE985477EBCA47199/image-size/large?v=v2&amp;px=999" role="button" title="amount1.PNG" alt="amount1.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="amount.PNG" style="width: 819px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99371iC7E56BB7A4BFCA8B/image-size/large?v=v2&amp;px=999" role="button" title="amount.PNG" alt="amount.PNG" /></span></P> Tue, 31 Jan 2023 21:57:03 GMT bhoomika_101 2023-01-31T21:57:03Z https://community.qlik.com/t5/Management-Governance/Negative-Amount/m-p/2032485#M24227 <P>I have payment amount in negative and decimal also. How to check less than 0 and greater than 0 amount?<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="amount1.PNG" style="width: 815px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99370iE985477EBCA47199/image-size/large?v=v2&amp;px=999" role="button" title="amount1.PNG" alt="amount1.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="amount.PNG" style="width: 819px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99371iC7E56BB7A4BFCA8B/image-size/large?v=v2&amp;px=999" role="button" title="amount.PNG" alt="amount.PNG" /></span></P> Tue, 31 Jan 2023 21:57:03 GMT https://community.qlik.com/t5/Management-Governance/Negative-Amount/m-p/2032485#M24227 bhoomika_101 2023-01-31T21:57:03Z https://community.qlik.com/t5/Management-Governance/Negative-Amount/m-p/2073936#M25032 <P>Seriously? Well easiest is to just check the value;<BR />&nbsp; if(payment_amount, 1, 0)<BR />That will check for any non Zero value.<BR />Or if you want to make it a little more clear what you are doing;<BR />&nbsp; if(payment_amount &lt;&gt; 0, 1, 0)</P> Mon, 22 May 2023 15:13:41 GMT https://community.qlik.com/t5/Management-Governance/Negative-Amount/m-p/2073936#M25032 Anders_Eriksson 2023-05-22T15:13:41Z