siliconhippy
37 posts
msg #34298
- Ignore siliconhippy |
12/9/2004 7:57:52 PM
I am trying to count the number of days when BOTH the volume and close is above previous days', but the count multiply is erroneous.
|
cegis
235 posts
msg #34341
- Ignore cegis |
12/12/2004 6:34:19 PM
siliconhippy,
VERY CLOSE!
What you need is the count() function in the set commands:
The count() makes the values of p and v zero (false) or one (true), so pv will now be zero (either/both false) or one (both true).
HTH,
C
|
siliconhippy
37 posts
msg #34345
- Ignore siliconhippy |
12/12/2004 10:04:38 PM
thx again. Now this shows why we need good documentation, that not only states the commands, but TIPs the users too about pitfalls.
siliconhippy
|