Where Expression Using Conditions on Two Fields

[#1]

Hi

I'm trying to create a variant on the following which also filters qICost_standard04 on cSource in the second two clauses. 

=-(sum( {$<cSource = {'OP'}>} qTotalFCost )
+
Sum( {$<cCategory = {'Direct'}>} qICost_standard04 )
+
Sum( {$<cCategory = {'Indirect'}>} qICost_standard04 ))

In SQL I would just use

SELECT qICost_standard04

WHERE cCategory = 'Direct'

AND cSource = 'OP'

Have tried assorted variations of brackets and <> and just becoming frustrated.

Any help would be much appreciated.

Cheers

Geoff

[Gysbert_Wassenaar · Accepted solution]

try: Sum( {$<cSource = {'OP'}, cCategory = {'Direct'}>} qICost_standard04 )

to get the sum of qlCost_standard04 where cSource = 'OP' and cCategory = 'Direct'

cCategory = {'Direct','Indirect'} is the selector for the sql equivalent cCategory in ('Direct','Indirect')

[#3]

Cool, sorted thanks Gysbert