Problem with hours in calendar

[#1]

Hello,

I have the following problem. I have a test table in excel where are 3 columns. The first one is the date in format 'd.m.rrrr hh', the second is the amount of sth and the last one is the same as the first but in number format.

As next I have a calendar (the smallest value is the hour) generate this way:

TempCalendar: 

LOAD 

               $(varMinDate) + (IterNo()/24)  As Num

               AutoGenerate 1 While $(varMinDate) + (IterNo()/24)  < $(varMaxDate);

The calendar seems to be OK. But I have a straight table by hours and only one value is different from the source. The value for the hour 13 is summarized into 12h. But WHY? I used this key between source and calendar to Date(floor(Num,1/24),'d.M.YYYY hh') as DateHours.

Is this because of the wrong way with generation calendar by hours of is the floor function inappropriate?

Thanks in advance,

Regards,

Peter

[Anonymous]

Hi Petr,

Please refer to below link:

Master calendar with hour

Regards

Neetha

[Anonymous]

Maybe related to formatting issues.

Try using numbers as key instead of "date + hour".

BR

Serhan

[giakoum]

put your data in a excel so that we can try this as well