topic Re: SUM IF FIELD IS NOT BLANK in App Development

SUM IF FIELD IS NOT BLANK

LEGION — Sat, 16 Nov 2024 19:06:17 GMT

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

Re: SUM IF FIELD IS NOT BLANK

marcus_sommer — Mon, 17 Feb 2020 11:48:07 GMT

You could try this:

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

or maybe this:

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

- Marcus

Re: SUM IF FIELD IS NOT BLANK

LEGION — Mon, 17 Feb 2020 12:56:53 GMT

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