I have to create two straight table/table box with the below requirement. My qvd has all the columns Project_name,Task,Amount and many more. Amount is a floating point number and i can have values like 0.00,but I want to ignore those as well in my expression. I don't need to do any sum of Amount. Just need to show the data as is but with the below condition. Can you please help me with the set expression that I will need to write in the Straight Table expression to replace the below two sql queries.
1st Table: Select Project_name,Task,Amount where Project_name is null and Amount<>0 order by Project_name,Task
2nd Table: Select Project_name,Task,Amount where Task is null and Amount<>0 order by Project_name,Task
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.