IF else in Bex
I have two columns that I use to calculate a Variance Column. But now I need to calculate a new column which would determine 'F' or 'U' depending on the value of the variance column. How can I do this?
For example if a value is > 1000 show 'F' else show 'U'
Yes, you can do that in Bex itself using Exception which will be there on top of your Query Designer Menu Bar.