If Statements in Expressions

[jagjivvt]

Hi

is there a way of using if statements in expressions to total up 2 value types e.g

my tables are

emp.type, where there are A S and W and another table has values for each emp.type. what i am trying to do is work out the cost of each emp type and display on straight table.

thank

[#2 · Accepted solution]

= SUM( IF( emptype = 'A' OR emptype = 'W', cost) )