Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Topic: Forumula to supress records Posted: 10 Apr 2018 at 3:41am
I have found a few posts on this, but I'm probably not fully understanding how this works...
I want to suppress certain records from my report. I can put a IS NOT in the select expert, but then it is stripping too much data.
My issue is that I am linking on application number, but I only want who sold insurance on the loan. This table has anywhere form 0-5 different items listed per each application number.
When nothing is suppressed, I think my data is wrong as the ins sold by is blank, when the table has data. But then when I suppress, the loans that were did not have ins sold are suppressed completely, when I still want those listed.
Suppressing from my formula is doesn't suppress anything and suppressing from the select expert suppresses to much.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 23 Apr 2018 at 10:27am
It sounds like the data is incorrect to begin with...a join is off or some other filter is being applied that blocks the records that you are after.
I think that once you can see the records that had insurance sold correctly, try the suppress again. If it is coming out blank when it should not be, that usually points to a join condition being incorrect.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
