9 Replies Latest reply: Aug 10, 2015 9:44 PM by arjun rao RSS

    Expression

    Prakash Puli

      Hi all,

       

      I have 2 columns. ID and Value like below.

       

       

      ID         Value

       

       

      1245       10

      1569        8

      2145       15

      2356       20

       

       

      Sales = count of the "Value" that anything starts with number "1" in ID column.

      Costs = count of the "Value" that anything starts with number "2" in ID column.

       

       

       

      Can someone tell me how to write the expression.

       

       

      Thanks