Doubt with and aggregate expression

rcandeo — Sat, 08 Aug 2009 00:44:34 GMT

I have this expression above that works in all lines, but in the line total, if there is any line with zero value, it returns an invalid value (-).

(sum(distinct aggr(avg(amount),document,Customer,company))+sum(amount_tax))*Tax /100

I´ve made a comparison testing if tax is zero, but it didn't work anyway.

if(Tax<>0,((sum(distinct aggr(avg(amount),document,Customer,company))+sum(amount_tax))*Tax /100),0)

Anyone can give a hint to solve my problem?

For information:

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.

topic Doubt with and aggregate expression in QlikView

Doubt with and aggregate expression