on 11-05-2015 6:42 PM
Hi,
In my IDT, iam trying to create an Month Object of type string in the format 001, 002, 003...012. Now i wanted to display this object as Jan, Feb, Mar...Dec.
Which condition better to go with either if else or case. If either of them, then could you please help me how to do this.
Thanks,
Dinya
Hi,
Use Case function to display the Jan,Feb etc..
Let say your Object is Month.
Then create one more object Like Month Name.
Syntax like.
CASE
WHEN @Select(Class\SMonth)='001'
THEN 'Jan'
WHEN @Select(IX Monthly\Start Date)='002'
THEN 'Feb'
WHEN @Select(IX Monthly\Start Date)='003'
THEN 'Mar'
upto 012
END
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What is the backend data base on universe?Also in some previous post you have concatenated the 0 with other object to display 001. you want to display Jan with 001 values object or different object.
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
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.