Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
Cool, sorted thanks Gysbert