Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

BOP last 5 days Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
fredmacc
Posted : Wednesday, March 9, 2011 7:30:46 PM
Registered User
Joined: 11/1/2010
Posts: 28
I have PCF BOP5>31 but it gives me something different than what I want.
I still get one green and 4 yellow BOP bars sometimes.
Julia or Michael said to enter this formula but I want 5 consecutive days of BOP
above 30 or 31.  The current day or yesterday and the 4 before that.  Not at any time
prior.
Thanks,
Fred
Naresh
Posted : Thursday, March 10, 2011 1:32:30 AM
Registered User
Joined: 10/23/2004
Posts: 251
Try this one. I tested it and it seems to work.

MIN(BOP,5) > 30

Does that help?
fredmacc
Posted : Saturday, March 12, 2011 4:18:52 PM
Registered User
Joined: 11/1/2010
Posts: 28
Naresh,
I tried it and believe it is working as I had hoped.
Thanks,
Fred
Users browsing this topic
Guest-1

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.