Jump to content

Limiting a formula to a condition

Jacob X

Recommended Posts


I will start by explaining what i’m trying to do. Referring to the pictures:

1- Flow: actual real-time flow. 
2- Design flow: a formula i created and typed a number, for example “188”. 
3- Percent: (Actual flow/Design flow)*100. 

I also created some conditions to define when the equipment is running, and a periodic daily condition. 

Basically, I want to display the “Percent” value when the equipment is running only. I have created a table to find its daily average during the daily condition, but the problem is that the values gets mixed with when the equipment is not running. 

For example, in one of the pictures, I’m getting a percentage of 39%, while it should be around 60%. The reason for the low percentage is that the algorithm included the time the equipment was not running.

Any recommendations?


thanks  IMG_1980.thumb.png.c6f2428e1d7709df346b11b9087eb501.png



Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...