Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys, i need some help please.
I'm Trying to get to a 'Stock Holding Figure' which is simply STOCK x COST but only if the field DEPARTMENT has been filled in. Basically perform the calculation if DEPARTMENT is NOT Blank.
=sum({(<[DEPARTMENT]={"*"} >)} ([Stock.ONHAND]*[Stock.AVRGCOST]))
Thank you so much
You could try this:
=sum({<[DEPARTMENT]={'*'} >} [Stock.ONHAND] * [Stock.AVRGCOST])
or maybe this:
=sum({<[DEPARTMENT]={"=len(trim([DEPARTMENT]))>0"} >} [Stock.ONHAND] * [Stock.AVRGCOST])
- Marcus
You could try this:
=sum({<[DEPARTMENT]={'*'} >} [Stock.ONHAND] * [Stock.AVRGCOST])
or maybe this:
=sum({<[DEPARTMENT]={"=len(trim([DEPARTMENT]))>0"} >} [Stock.ONHAND] * [Stock.AVRGCOST])
- Marcus
Thank you so much, the second line worked like a charm.