How to use Set Expression in front end instead of the 'if' statement in script.

[Architect]

Hi,

I below is the 'IF' statement that I want to replace with 'Set expression'

Please note this expression is used inside the column expression of a Chart.

If(
$(v_Rec_GM)>0 and ([Rec. Sales Price])>= $(vLowcomp), 'G2',
If( $(v_Rec_GM)<=0 and ([Rec. Sales Price])>= $(vLowcomp), 'G1',null)
)

Here I want to replace this IF statement with a Set expression. Not to do in the script, only to change in column expression.

@marcus_sommer 

@jwjackso 

@NitinK7 

[Architect]

Hi,

I below is the 'IF' statement that I want to replace with 'Set expression'

Please note this expression is used inside the column expression of a Chart.

If(
$(v_Rec_GM)>0 and ([Rec. Sales Price])>= $(vLowcomp), 'G2',
If( $(v_Rec_GM)<=0 and ([Rec. Sales Price])>= $(vLowcomp), 'G1',null)
)

Here I want to replace this IF statement with a Set expression. Not to do in the script, only to change in column expression.

@marcus_sommer 

@jwjackso 

@NitinK7 

[Dalton_Ruer]

Set Analysis isn't going to permit nested conditions. It would be used to filter the recordset to fields that had certain values.