locked
sum with condition function for expresssion field RRS feed

  • Question

  • User-1075092149 posted

    i woud like to sum specific value ,how can i write a foumula to create a expression field.

    for example

    sum(field_1) where field_2 in ('A','B','C')

    is it sum function with condition. i don't know how to write the formula.

    sum(column, condition)

    i would like to accumulate sum some field where field_2 in ('A','B','C')

     

    Thursday, August 25, 2011 4:48 AM

All replies

  • User2131854062 posted

    hi,

    Select sum(field1) from tbl where fileld2 in ('a','b','c')

    Thursday, August 25, 2011 7:43 AM
  • User-1075092149 posted

    hi,

    Select sum(field1) from tbl where fileld2 in ('a','b','c')

     

    it is sql ,seems can't insert to expreession field .

    can u tell me how to add this sql to get the result.

    any reference for me. thanks.

    Friday, August 26, 2011 12:13 AM