Script help

[#1]

hi can someone help me please convert the folloowing into set analysis code

if (pers_race LIKE 'Black' AND pers_isowner LIKE 'Y' AND isNull(Comp_Deleted) AND isNull(Terr_Deleted)  AND IsNull(Pers_Deleted) AND comp_status = 'WorkingWith' AND Terr_ChildCount = 0, count(PeLi_PersonId))

thanks alot

[Gysbert_Wassenaar]

Try:

count({<pers_race={'Black'},pers_isowner={'Y'}>,Comp_Deleted-={'*'},Terr_Deleted-={'*'},Pers_Deleted-={'*'},comp_status={'WorkingWith'},Terr_ChildCount={0}>} Peli_PersonID)

The expression editor flags -= as wrong (underlined red), but that's a bug in the editor.

[#3]

i am a bit confused here so how can you write the one below which is comparing two fields?

if (netw_Secterr =Terr_TerritoryID AND Terr_ChildCount = 0 AND  netw_eventfocus = 'Black'  And isNull( netw_Deleted), count(netw_NetworkEventID))

[jonathandienst]

Hi

You are aware that

     If(  <cond> ,  Sum(....))

is not the same as

     Sum(If( <cond>, ....))

The first one, as per the orogonal post, does not lend itself to a set expression because the condition is outside the aggregation function...

Just my 2c - perhaps the OP meant a sum(if())...

Jonathan