Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
if ( Index(GetFieldSelections(Quarter), 'Q1') and Index(GetFieldSelections(Quarter), 'Q2') , Column * 0.4)
Try this,
If( Wildmatch(GetFieldSelections(Quarter),'Q1*Q2*'), Column * 0.4)
Thats correct. Thanks
Correct answer.
Thanks