Skip to Content
0
Oct 29, 2013 at 07:17 AM

Year values need to be merged

18 Views

Hi Experts,

I Have year and month Columns,

I am using universe created on multi provider, one data provider is giving year numbers and months as month numbers but another data provider is giving # instead of year and month.

The year having the values like below:

Year

2002

2003

2004

2005

2006

2007

2008

2009

2010

2011

2012

2013

#

And the Month having the values like below:

1

2

3

4

5

6

7

8

9

10

11

12

#

My requirement is when i select the month 1 then 1 and # need to be selected if i select 2 then 2 and # need to be selected like this for all months

and for year also when i select the year 2012 then 2012 and # need to be selected if i select 2013 then 2013 and # need to be selected like this when ever i take year selected year and # need to be selected.

I Have done for month the logic is =If([Month] InList("1";"#");1;If([Month] InList("2";"#");2)), like this I wrote for 12 months, but for year I am not able to get the logic.

Please give some inputs,

Thanks,

G Sampath Kumar