how to create a new filed value depending on other filed values

[dseelam]

Help,

I have field order type  a,b,c,d,e & field AccNum 1,2,3,4,5, in my QVW where a=1, b=2&5, c=3, d=4 & e=5&2 & it has many other columns related to account numbers

but now I want to create a new order type f where it should also be equal to 3 &4

I failed using if statement and match statement

when i use them I can create new order type f equals 3& 4 but I cant filter other columns

how to accomplish this ?

Message was edited by: Dinesh Reddy Seelam

[vinieme12]

IS this what you are expecting?

[dseelam]

Awesome thank you so much

[dseelam]

Vineeth,

Thanks for your reply Rakesh answered me what I am expecting

thanks