cancel
Showing results for 
Search instead for 
Did you mean: 

Set Flag 1 or 0 based on char value in BEx query

Former Member
0 Kudos

Hello,

I have following req.

If Cust Ac grp is "ZWD" then I need a column with value '1' else value '0'. I need flag 1 or 0 based char value of cust ac grp.

I tried formula variable with replacement path but how to compare whether the replaced value is ZWD or not.

Please help me on this or any other alternate way of achieving it.

Thanks with regards,

Prafulla

View Entire Topic
Former Member
0 Kudos

Hi,

Create a replacement path variable for the characteristic and place it in column A.

Then, create a formula B and use the IF then else statment based on the column A.

Hence, B would show 1 or 0 based on the characteristic.

0 Kudos

how can u have replacement path on char variable by giving values. Its mostly used on date or number. I think ur answer is incorrect.