AGGR

[johnan]

Hi, what im missing out here?

I want the highlighed post to tell me "+-" on both.

I'ts same order, sku and the sum is 0

The expression is now:

aggr(if(Sum(QUANO = '0'),'+-','N/A'),SHPPO,PRDNO)

[martinpohl · Accepted solution]

because quano also is a field in the table, the calculation is done also for the individual field

I suggest

aggr(if(Sum(total <SHPPO,PRDNP> QUANO) = '0','+-','N/A'),SHPPO,PRDNO)

[johnan]

yeah, one step closer 🙂

I want even the first post to show +-

[johnan]

Found it

aggr(if(Sum(total <SHPPO,PRDNO> QUANO) = '0','+-','N/A'),SHPPO,PRDNO,QUANO)

Thanx 🙂