Help writing expression

[hopkinsc]

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

[#2 · Accepted solution]

Hi

try this :

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

Regards

Gills

[hopkinsc]

Thanks very much Gills..