topic Re: What's wrong with this expression? in QlikView

What's wrong with this expression?

ccb-it2013 — Mon, 12 Dec 2016 18:09:44 GMT

Hi guys,

Can someone tell me what is wrong with the expression below? Been staring at this too long, and I guess I don't see why the token doesn't match:

// For invoices and removing the pallets

sum(if(pallet<>'P' and trntype='I',

// For invoices and replacing price with paprice

(if(price<>0,( //To check styles with 0 amount and not a pallet

((invqty)*price)*rate))),

(((invqty)*pprice)

*rate))),

// For credits

(((-(invqty)*price)*rate)

Please help.

Thanks,

vishsaggi — Mon, 12 Dec 2016 18:49:57 GMT

Try this?

= sum(

if(pallet<>'P' and trntype='I',(if(price<>0,(((invqty)*price)*rate))), (((invqty)*pprice)*rate)),(((-(invqty)*price)*rate)))

sunny_talwar — Mon, 12 Dec 2016 18:50:28 GMT

May be this:

Sum(

If(pallet <> 'P' and trntype='I',

If(price <> 0, invqty * price * rate,

invqty * pprice * rate),

-invqty * price * rate))

Anonymous — Mon, 12 Dec 2016 19:01:55 GMT

Overall there seems to be one more opening bracket than closing brackets.

Also the closing bracket for your sum( appears to be before the comma at the end of the line before the // For credits comment.