Currently, I am attempting to do the following: IF [R52 Indv Quotes] = 0 AND ISNULL([Lead Time Range]) then 1 else 0 end. Along with the inverse of the latter of which is IF NOT ISNULL([Lead Time Delivery Range]) AND [R52 Indv Quotes] = 0 then 1 else 0 end. However, when I do that for those to commands I get the same amount for my sums. Am I doing the IS NULL and NOT ISNULL function incorrectly? My objective here is to gather products not quoted with a jobsite delivery versus products not quoted without a jobsite delivery.
Would you be able to attach a sample data set, Santiago? I think this should be a pretty straightforward issue to solve, but without any data to work with it'll be tricky to validate. Even a small sample that demonstrates where these null values might exist would be helpful.