Hi All I am facing one problem in set analysis in using (NOT IN) Clause . I am having cases where i am having file Nos (DebtNo.) those are present in Current month(Suppose-Aug) and Having File No those are present in Previous month that will be July . Now i want one result using set anlysis in which i can get cases those were present in July BUT NOT IN August .. ....
or i can take another case like i want cases from august(Current Month) those were absent (Not in) in July .
How can i get this result using set anlysis because i am using current and previous month logic here . Please find out attached doccuement for your refrence and suggest if you can do the needfull changes in that doccument.
As per my uderstanding we should use (NOT IN) Syntax but i dont know how to use or implement this is set analysis... Please help me ..........
The minus sign is used as the exclusion operator. Open Help and search for "Set Analysis" to see an article that will give you all the syntax you need to accomplish this.
This post has 0 verified answers | 0 Replies | 1 Follower
