on 12-11-2009 2:54 PM
Hello,
I am trying to build a universe based on an excel datasource.
I need to create an object "Age braket" with this kind of synthax :
case when Age < 20 then "0-20" else "+20" end
But I don't find what to use instead of "case when" to be compatible with an excel datasource.
Can you help me please ?
Thanks a lot for all your help.
I hope someone would have the response.
Regards
Emi
Hi,
Try this syntax:
IIF (Age < 20, '0-20', '+20')
Regards,
Didier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
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.