topic Negative Values in QlikView https://community.qlik.com/t5/QlikView/Negative-Values/m-p/224045#M76505 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the attached document, I am doing the percentage difference between rrp and cost, I have a issue where there are two negative fields and this will show this as a positive, has anyone have any suggestions to show this as a negative?</P><P>Thanks</P></BODY></HTML> Mon, 21 Feb 2011 13:33:06 GMT ivandrago 2011-02-21T13:33:06Z Negative Values https://community.qlik.com/t5/QlikView/Negative-Values/m-p/224045#M76505 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the attached document, I am doing the percentage difference between rrp and cost, I have a issue where there are two negative fields and this will show this as a positive, has anyone have any suggestions to show this as a negative?</P><P>Thanks</P></BODY></HTML> Mon, 21 Feb 2011 13:33:06 GMT https://community.qlik.com/t5/QlikView/Negative-Values/m-p/224045#M76505 ivandrago 2011-02-21T13:33:06Z Negative Values https://community.qlik.com/t5/QlikView/Negative-Values/m-p/224046#M76506 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please use the below expression</P><P></P><P></P><P>=</P><P><B>if</B>(<B>[Total Cost]</B>&lt;0 <B>and</B> <B>[Total RRP]</B>&lt;0,-1,1) * (<B>[Total Cost]</B>/<B>[Total RRP]</B>)</P><P>refer the attached document.</P><BR /><BR /> <BR /><BR /></BODY></HTML> Mon, 21 Feb 2011 13:40:57 GMT https://community.qlik.com/t5/QlikView/Negative-Values/m-p/224046#M76506 maneshkhottcpl 2011-02-21T13:40:57Z Negative Values https://community.qlik.com/t5/QlikView/Negative-Values/m-p/224047#M76507 <HTML><HEAD></HEAD><BODY><P>HI Please refer the attached document.</P></BODY></HTML> Mon, 21 Feb 2011 13:46:01 GMT https://community.qlik.com/t5/QlikView/Negative-Values/m-p/224047#M76507 maneshkhottcpl 2011-02-21T13:46:01Z