set analysis with a field > 0

[andyrebs]

Hello ,

I am sorry for the very simple question I am doing, but, knowing how efficient you are, I will do it.

I want to create an expression with selection of the products that are in stock. I tryed with this expression below, but it is not correct.

sum({$<[Stock]>{0}>} Sales)

Thanks

Andrea

[MayilVahanan · Accepted solution]

HI

Sum({<Stock ={">0"}>}Sales)

Hope it helps

[CELAMBARASAN]

Hi,

You shoul use > , < inside the braces {}

sum({$<[Stock]={>0}>} Sales)

or

sum({$<[Stock]={">0"}>} Sales)

[jagan]

Hi,

Try this

=Sum({<Stock ={'>0'}>} Sales)

Regards,

jagan.

[#5]

Hi

use this

sum({<stock={">0<=4"}>} sales)