Expression and Where Clause

• keywestfl9

  SSCertifiable

  Points: 5215

  More actions

  July 25, 2008 at 1:32 pm

  #196237

  Field Expression i would like to sum of the value based on other field data value.

  Example

  Fee value Condition Field

  100 Salary

  300 Tel Bill

  500 Salary

  output should be like 100+500 when the condition is salary.

  how can i achieve it in expression?

• toolman-352714

  SSCrazy

  Points: 2495

  More actions

  July 25, 2008 at 1:56 pm

  #848682

  =sum(iif(condition field = "salary",value field,0))

  [font="Comic Sans MS"]toolman[/font]
  [font="Arial Narrow"]Numbers 6:24-26[/font]