Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
try this :
Sum(StockValue)/Sum({$<[Stock Reason]=, DEPT-={'U'}>}SalesValue)
Regards
Gills
Hi
try this :
Sum(StockValue)/Sum({$<[Stock Reason]=, DEPT-={'U'}>}SalesValue)
Regards
Gills
Thanks very much Gills..