topic Help me with this aggregation in QlikView https://community.qlik.com/t5/QlikView/Help-me-with-this-aggregation/m-p/153110#M30282 <HTML><HEAD></HEAD><BODY><P></P><P>I have this expression below that works in all lines, but in the line total, if there is any line with zero value, it returns an invalid value (-).</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />(sum(distinct aggr(avg(amount),document,Customer,company))+sum(amount_tax))*Tax /100<BR /></PRE><BR /><BR /> <P>I´ve made a comparison testing if tax is zero, but it didn't work anyway.</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />if(Tax&lt;&gt;0,((sum(distinct aggr(avg(amount),document,Customer,company))+sum(amount_tax))*Tax /100),0)<BR /></PRE><BR /><BR /> <P>Anyone can give a hint to solve my problem?</P><P>For information:</P><P>I have in my table the amount for document and I need to find out the tax value. I am using an aggregate expression cause I have the amount of the document in all lines (a document can have n lines), and if I don't do this aggregate, It'll multiply the tax value by the lines of the document.</P><P></P></BODY></HTML> Mon, 10 Aug 2009 20:01:23 GMT rcandeo 2009-08-10T20:01:23Z Help me with this aggregation https://community.qlik.com/t5/QlikView/Help-me-with-this-aggregation/m-p/153110#M30282 <HTML><HEAD></HEAD><BODY><P></P><P>I have this expression below that works in all lines, but in the line total, if there is any line with zero value, it returns an invalid value (-).</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />(sum(distinct aggr(avg(amount),document,Customer,company))+sum(amount_tax))*Tax /100<BR /></PRE><BR /><BR /> <P>I´ve made a comparison testing if tax is zero, but it didn't work anyway.</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />if(Tax&lt;&gt;0,((sum(distinct aggr(avg(amount),document,Customer,company))+sum(amount_tax))*Tax /100),0)<BR /></PRE><BR /><BR /> <P>Anyone can give a hint to solve my problem?</P><P>For information:</P><P>I have in my table the amount for document and I need to find out the tax value. I am using an aggregate expression cause I have the amount of the document in all lines (a document can have n lines), and if I don't do this aggregate, It'll multiply the tax value by the lines of the document.</P><P></P></BODY></HTML> Mon, 10 Aug 2009 20:01:23 GMT https://community.qlik.com/t5/QlikView/Help-me-with-this-aggregation/m-p/153110#M30282 rcandeo 2009-08-10T20:01:23Z