1 Reply Latest reply on Dec 21, 2011 5:51 AM by try67

    2 issues; the IF expression, and the Count expression use

    Ricardo 52

      I'm unable to get a simple IF statement to cooperate; and its very basic I'm sure it's because of something that I'm missing.

      The issue is if a 'field' is > than 0, then count that field (and each subsequent field (that has an amount in it)), for a total number fields with an amount greater than 0 or " ".

      work fine in Excel, can't seem to get it in Javascript.

       

      Thanks