topic How to resolve this error? in QlikView https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98116#M751693 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I have a table a shown below;</P><P></P><P><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217236_1.PNG" style="height: auto;" /></P><P></P><P>I am calculating YTD as Current month - Baseline columns. But the yellow marked value is wrong (-32864-0 = -32864). </P><P></P><P>Why is my value showing as -? Any help</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bhaveshp90 2020-11-25T16:16:04Z How to resolve this error? https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98116#M751693 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I have a table a shown below;</P><P></P><P><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217236_1.PNG" style="height: auto;" /></P><P></P><P>I am calculating YTD as Current month - Baseline columns. But the yellow marked value is wrong (-32864-0 = -32864). </P><P></P><P>Why is my value showing as -? Any help</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98116#M751693 bhaveshp90 2020-11-25T16:16:04Z Re: How to resolve this error? https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98117#M751694 <HTML><HEAD></HEAD><BODY><P>hi </P><P>the problem is that the value is missing it's not zero</P><P>and you can't do a calculation with missing values</P></BODY></HTML> Wed, 31 Oct 2018 20:27:52 GMT https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98117#M751694 lironbaram 2018-10-31T20:27:52Z Re: How to resolve this error? https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98118#M751695 <HTML><HEAD></HEAD><BODY><P>Yes it is missing, Is there a way to avoid it. even my expression If(Variance_YTD = ' ', 0, xxxxxxx) not working. </P></BODY></HTML> Wed, 31 Oct 2018 20:47:06 GMT https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98118#M751695 bhaveshp90 2018-10-31T20:47:06Z Re: How to resolve this error? https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98119#M751696 <HTML><HEAD></HEAD><BODY><P>RangeSum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Current month, - Baseline) </SPAN></P></BODY></HTML> Wed, 31 Oct 2018 20:52:45 GMT https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98119#M751696 MarcoWedel 2018-10-31T20:52:45Z Re: How to resolve this error? https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98120#M751697 <HTML><HEAD></HEAD><BODY><P>thank you Marco, it worked like a charm. </P></BODY></HTML> Wed, 31 Oct 2018 21:04:16 GMT https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98120#M751697 bhaveshp90 2018-10-31T21:04:16Z Re: How to resolve this error? https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98121#M751698 <HTML><HEAD></HEAD><BODY><P>We can also use if(isnull(field), 0, xxx). </P></BODY></HTML> Wed, 31 Oct 2018 21:05:04 GMT https://community.qlik.com/t5/QlikView/How-to-resolve-this-error/m-p/98121#M751698 bhaveshp90 2018-10-31T21:05:04Z