Restrict data based on the field value in staright chart

[Anonymous]

Hello All,

I need some help in finding a way to restrict data based on value in a field, I have a field quantity, I wanted to show the data in the straight table object where quantity > 0. Any help is highly appreciated. I tried creating an expression like

=sum({$<[Item Quantity] ={>0}>}[Item Quantity]) ,but it did not work.

Thanks

Heera

[ramoncova06]

try using quotes inside of the filter

=sum({$<[Item Quantity] ={">0"}>}[Item Quantity])

[Kushal_Chawda]

=Sum(if([Item Quantity] >0,[Item Quantity] ))

[maxgro]

>0 is a search and it needs double quotes ">0" (it works with single too  '>0')

[Anonymous]

Thanks Ramon for the reply, however my data still showing records with quantity = 0

[Anonymous]

Kush,

I tried using this logic, its not filtering the data with quantity = 0.

[ramoncova06]

the quotes should work, do you have items with null quantity ?

[Kushal_Chawda]

Please post the sample app

[Anonymous]

Massimo,

I used double quotes , but I could get the desired result. I wanted to show the data in chart where quantity >0.

[Anonymous]

No it doesn't have, its either >0 or less <0.