on 04-16-2015 9:09 AM
I've been trying to create a new view column with logic similar to :
If <field> = 'A' then 'Apples'
else if <field> = 'B' then 'Bananas' ....
Case <field>
When 'A' then 'Apples'
When 'B' then 'Bananas'
etc ....
I've read that 'IF' cannot be used in the New Column editor; I did try anyway (as SAP documentation not always correct) but could not get it to work.
Could not find reference to a CASE statement.
Does anyone know if a function/statement or other workaround that could be used to get this logic to work ?
Hi Simon,
You can use decode((<field> = 'A'), 'Apples', (<field> = 'B'), 'Bananas', 'Unknown')
Regards
Nigel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.