Jump to content

Formula and calculation with step trigger and summation.


Recommended Posts

I am trying to use multiple signals and trying to sum them when another signal has value of 1. How can I create the formula?

  • If $t1 = 1 then sum($t2*$t3+$t4*t5)

  • I would like the sum to go to zero as soon as $t1 value changes from 1
    I tried running sum but if I limit the period the last sum that is still ongoing will not be calculated. Also tried combewith() but no luck.
    Thanks in advance.

Link to comment
Share on other sites

  • Seeq Team

Hi Ario,

The Seeq version of Excel's IF function is called splice. In order to do what you would like to do, you would want to do 2 steps:
1. Create a Value Search for when $t1 = 1
2. Create a Formula that splices either a value of 0 or the sum formula depending on whether $t1 is 1 or not. The formula would look like:


This effectively says make the value 0 when a capsule for $t=1 is not present, but when a capsule becomes present, make the value of the signal the sum of $t2*$t3+$t4*$t5.

Edited by Joe Reckamp
  • Like 2
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...