Forum Discussion

zamond1's avatar
zamond1
Community Member
7 hours ago

How to assign the quotient of 2 numeric variables to a 3rd numeric variable?

Hi, if anyone's available, I could really use some help with this:

I want to set up a SIMPLE calculation that involves 3 numerical variables:

  • totalRevenue
  • monthlyBurnRate
  • numMonths

totalRevenue and monthlyBurnRate are user-inputted values.

numMonths is the quotient of:

  • totalRevenue / monthlyBurnRate

So, hypothetically, if the user entered a value of 9000 for totalRevenue, and 4000 for monthlyBurnRate, the quotient (numMonths) of this calculation would be 4.5.

I have stared at the trigger wizard until my head hurts, and I cannot find a way to do this. I can set up an operation that divides totalRevenue by monthlyBurnRate, but it seems there's no way to assign the outcome/quotient to another variable, whether preexisting (such as numMonths) or on the fly. This is driving me CRAZY.

I asked AI how to do this, and it keeps providing solutions that (like me) it apparently thinks makes sense and would LIKE to see but that DON'T exist lol. And when I tell it that its solutions don't exist, it says that yes, I'm right, it was hallucinating, which is pretty much about where I'm at right now...

Thanks in advance!