Create function to calculate total duration with multiple conditions

[Esther]

Hello Everyone, 

I hope you are doing well. I need some help with creating a function. I have multiple conditions that I have created that tell me if the equipment is stopped, lag, standby, or other attributes. 
I want to be able to be able to: 
ADD Durations for when equipment is stopped and in lag OR when the equipment is stopped or standby.  

ADD Durations for when equipment is stopped but not in lag or standby. 

The example variables are in hours. 

Stopped ($i5)

Standby($i6)

Lag ($i)

I would appreciate the help. 

[Thorsten Vogt]

Hi Esther,

based on the information you provided I would create a condition for each of the two durations you want to calculate. To do this in formula I first recommend you to rename the variables for better readability of the formula.

For the first one ("ADD Durations for when equipment is stopped and in lag OR when the equipment is stopped or standby") you may use:

 ($stopped && $lag) || ($stopped || $standby) //-> can be shortened to $stopped || $standby

For the second one ("ADD Durations for when equipment is stopped but not in lag or standby") try:

$stopped && !($lag || $standby)

Depending on what you want to do with the duration you may use different tools for calculation (e.g. Signal from Condition, Scorecard Metric, use of  capsule properties, ...)

Let me know if you need more help.

Regards,

Thorsten

[Esther]

Thank you! I appreciate the help. 
I would also like to schedule a signal for these conditions to count the hours on monthly intervals. Is there any way I can designate that? 

Thank you, 

Esther

[Thorsten Vogt]

Hi Esther,

you can do this the following way:

1. Create a Periodic Condition (found in Tools - Pane):

2. Use Signal from Condition to calculate the total duration.

 

Result:

Regards,

Thorsten