logical operator

[engr_farhanqadr]

Dear Folks,

I am trying to write logic where I need to multiply a Column with 0.4 when quarter Q1 and Q2 both selected. but I am failed to do so

if ( GetFieldSelections(Quarter) = 'Q1' and GetFieldSelections(Quarter) = 'Q2' , Column * 0.4)

please guide.

Thanks

[tresB]

Try like:

if ( Index(GetFieldSelections(Quarter), 'Q1') and Index(GetFieldSelections(Quarter), 'Q2') , Column * 0.4)

[tamilarasu]

Try this,

If( Wildmatch(GetFieldSelections(Quarter),'Q1*Q2*'), Column * 0.4)

[engr_farhanqadr]

Thats correct. Thanks

[engr_farhanqadr]

Correct answer.

Thanks