SUM IF FIELD IS NOT BLANK

[LEGION]

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

[marcus_sommer · Accepted solution]

You could try this:

=sum({<[DEPARTMENT]={'*'} >} [Stock.ONHAND] * [Stock.AVRGCOST])

or maybe this:

=sum({<[DEPARTMENT]={"=len(trim([DEPARTMENT]))>0"} >} [Stock.ONHAND] * [Stock.AVRGCOST])

- Marcus

[LEGION]

Thank you so much, the second line worked like a charm.