4 Replies Latest reply: Dec 2, 2014 5:21 PM by Andrew Houston-Floyd RSS

    Expressions - Ignore rows with missing field values

    Andrew Houston-Floyd

      Hi everyone,

       

      I have a simple expression to calculate product age: (Year - [First Year Delivery]). How do I tell the expression to ignore rows where [First Year Delivery] is blank? Those rows are creating results that distort my later calculations of averages.