on 07-23-2014 3:18 PM
How to add automatically months to a quarter column, for example if it's 20122 then it should automatically add 201204, 201205,201206.
Can we generate using caluclated column if we have quarter ?
hi Ram,
What is the logic here? Appending the month at end is not the problem here. But how would the system know what month to append 04 or 05 or 06?
Benedict
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Ram,
For this you will have to create three separate Calc. columns,
CC1 would be CASE('Quartercolumn',20121,2012101,20122,2012204,20123,201237,20124,2012410)
CC2 would be CASE('QuarterColumn',20121,2012102,20122,2012205 and so on
CC3 would be CASE('QuarterColumn',20121,2012103,20122,2012206.....
You will have to create three unions and in first union map CC1, in second map CC2 and in third map CC3 to the same target column.
Thanks,
Benedict
Appreciate all your help.
Created the join between the quarter column and month column in different tables using below logic
if(in(rightstr("0CALQUARTER", 1), '1') = 1, leftstr("0CALQUARTER",4)+'01', if(in(rightstr("0CALQUARTER", 1), '2') = 1, leftstr("0CALQUARTER",4)+'04', if(in(rightstr("0CALQUARTER", 1), '3') = 1, leftstr("0CALQUARTER",4)+'07', if(in(rightstr("0CALQUARTER", 1), '4') = 1, leftstr("0CALQUARTER",4)+'10',''))))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This is bringing only first month of the quarter
Is there any way we can bring max month of quarter by modifying this
if(in(rightstr("0CALQUARTER", 1), '1') = 1, leftstr("0CALQUARTER",4)+'01', if(in(rightstr("0CALQUARTER", 1), '2') = 1, leftstr("0CALQUARTER",4)+'04', if(in(rightstr("0CALQUARTER", 1), '3') = 1, leftstr("0CALQUARTER",4)+'07', if(in(rightstr("0CALQUARTER", 1), '4') = 1, leftstr("0CALQUARTER",4)+'10',''))))
Quarter data would be in following manner 20141/20142/20143/20144
Month data would be in following manner 201401/201402/201403/201404 etc
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.