Help writing expression

hopkinsc — Mon, 19 Sep 2011 12:55:18 GMT

Hi all,

I am trying to write an expression to give me WASTE as a % of SALES.

The calculation is:

StockValue / SalesValue

but i need it to exclude any selections made from the field [Stock Reason], so this is what i have so far which seems to work

Sum(StockValue)/Sum({$<[Stock Reason] = >}SalesValue)

But i also need to exclude any sales from DEPT = U .

This is where i am having problems, can anyone help me to write the expression to do all of the above?

so..

StockValue needs to be divided by SalesValue excluding Dept U and ignoring selections from StockReason

Any help woulf be appreciated..

Thanks

Mon, 19 Sep 2011 13:11:43 GMT

try this :

Sum(StockValue)/Sum({$<[Stock Reason]=, DEPT-={'U'}>}SalesValue)

Regards

Gills

hopkinsc — Mon, 19 Sep 2011 13:29:22 GMT

Thanks very much Gills..

topic Help writing expression in QlikView