This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello - I know there have been multiple posts regarding this question but I am not having any luck. I am trying to do all these filters in one job. The one filter that is blank is CRM FRISK is null. Everything I'm trying is not working. any direction would be much appreciated.
@jrgo you have the right idea of what I'm trying to do. I'm basically trying to clean up this flow so it looks more presentable and clean. The statement you gave me makes sense, but now I'm not getting any data. All records are coming out as false. Any ideas? Your formula makes sense to me.
The formula I'm using now is below. I only need the total AR balance greater than 50000. I took what was given earlier in this post and added the >50000. Doesn't make sense to me why this wouldn't work and only come back with falses after these same filters shown in my original post works.
![Total AR Balance] > 50000 AND [%] >= 40 AND [FSS] <= 20 AND ISNULL([CRM FRISK]) AND NOT [Risk Category] IN("MISFRT","YARD","FLIP","CARREP")
No need to apologize! I'm just a newbie trying to learn! My last question Is there a way to tie the trues and falses into one worksheet on different sheets? So I want the true's on one sheet and the falses on another in one document?