IF statements on field in set analysis

[#1]

hi all,

I am trying to do something with set analysis and have come across a problem.

I have the following issue:

I need to create a set where the field could change...  rather than the value.

so, for example:

=count({< if(primary_date = 0, secondary_date, primary_date) = {">=$(v_TargetDate)"} >} orders)

any help would be greatly appreciated!

thanks!

[sunny_talwar]

Not sure what you are trying to do? Can you expand by providing a sample?

[Mark_Little]

HI

Try

IF( Primary_Date = 0,

    count({< Secondary_date= {">=$(v_TargetDate)"} >} orders) ,

    count({< Primary_Date = {">=$(v_TargetDate)"} >} orders)

    )

Mark

[Gysbert_Wassenaar]

=count({< primary_date = {0}, secondary_date = {">=$(v_TargetDate)"} >+<primary_date = {'>0'}, pimary_date = {">=$(v_TargetDate)"} >} orders)

[mclen_vj]

To keep it salable, you can try this:

Var1 = if(primary_date = 0, 'secondary_date', 'primary_date')

Var2 = count( {<$1={">=$(v_TargetDate)"} >}   orders)

Execute as : =$(Variable2( Variable1 ))

Regards, VJ

[anushree1]

Hi ,

You could probably create a variable like v_date =if(primary_date = 0, secondary_date, primary_date)

and then use it in the set expression as below

=count({< v_date= {">=$(v_TargetDate)"} >} orders)

[maxgro]

you can also add a field in the script with the if condition

the set analysis will be easier on this new field

[#8]

Hope this helps.