Hi,
I am facing issue in Datahandling condition. I need to suppress records with negative sales Values (highlighted in below screenshot. My expression for sales value = Sum({<source_file_name={'CLOSED_PERIOD_SALES'}>}Amount_USD).
I have condition in data handling "if(Sum({<source_file_name={'CLOSED_PERIOD_SALES'}>}Amount_USD)<0,1,0)" and unchecked include zero checkbox in datahandling. It should give me these negative records, instead it does not give me any data.
I am not sure what I am doing wrong here, Can anyone please help me with this issue.
![ArchanaB_0-1608017604282.png ArchanaB_0-1608017604282.png](https://community.qlik.com/t5/image/serverpage/image-id/45661i9375FB84180C354D/image-size/medium?v=v2&px=400)
thank you in advance.