Rank: Member
Groups: Registered, Registered Users
Joined: 12/21/2009(UTC)
Posts: 10
|
Hi,
I am using the CUM function to count back the no. of instances ie it is like this, i use 60 minute charts.
cum( if(hour()=10.30 , 1,0))
It does not work and I get zero as the answer, any reason for this behaviour?
Your help is most welcome
Thanks
-kalyan
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi Kalyan
Hour() returns an integer (never a fraction) so your If() condition is never TRUE. On hourly charts "Hour()=10 AND Minute()=30" would never be TRUE either.
Roy
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 12/21/2009(UTC)
Posts: 10
|
Roy,
Thanks a million.
It works.
Thanks
-kalyan
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
