3 Replies Latest reply: Jul 13, 2012 3:40 PM by Jose Tos RSS

    What is the difference between these expressions?

    Rebecca Molstad

      I have two expressions, one to count null values and one to count non-null values. However, they seem to be pulling the opposite thing...

       

      count({$<FeeOne={"*"}>}Shipments)  <<<Looks like it counts null values, based on my data set...

       

      Count(if(IsNull(FeeOne),Shipments))         <<<Looks like it counts non-null values, based on my data set...

       

       

      I am confused. Help?