Dimension problem

[#1]

Hello!

I am having a working application where I am using the date time to select values. Suddenly we decided to add the target values. Then i tried to read the target values from the excel file and name the date time field (Month) to the same name as the Month we already suing in the application. Things works in the script but the problem is that the list of values in my Month field are now having doubles. That is to say i downloaded the target values for all the months of 2011 (jan, feb ...dec) but the actual values are only available for jan, feb, mar now.

The Month list is now jan, feb, ....dec, jan, feb,dec (Suddenly 15 months instead of 12.

Is there a good reason why is this like this?

Any ideas on how to overcome this problem. What i need is to be able to compare target and actual values.

Regards

Hafez

[#2 · Accepted solution]

Hello again

Sorry for this but i solved it my self it was related to the Text and date thing in my excel.