1 Reply Latest reply on Oct 15, 2018 1:54 PM by Vincent Baumel

    Calculated Field: IF statement nested with a ISNULL statement.

    Santiago Canon

      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.