Optimizing Revenue Generation: Handling Zero Values in AI Outputs

Need help, I'm trying to enrich the company revenue using a waterfall. Where the first step is simple google lookup for public information. 2nd onwards I'm using tools to find revenue. But the problem is, if Ai doesn't find anything on google it returns "0" and other tool don't run because "0" is also a valid output. hence it shows "run condition not met. Is there a way to return a emty value when revenue in not found by AI?? Or setup a condition that says, run the remaining tools if the value is "0" I hope i didn't make it confusing to understand 😐

2 comments

Channeled
APP
·
·
To address your issue, we can use conditional runs to set up the logic you need. Here's how you can approach this: 1. For the Google lookup step, use an AI formula to return an empty value instead of "0" when no revenue is found. 2. For the subsequent tools, set up a conditional run that allows them to execute even if the previous step returned "0" or an empty value. To implement this: 1. Go to the "Run Settings" of your Google lookup action. 2. Click on "Use AI" under Conditional Run. 3. In the prompt, you can type something like: "Return an empty value if no revenue is found, otherwise return the found revenue." 4. For the following tools, set up a conditional run that executes if the previous step's result is empty or "0". You can use the AI to generate these formulas by describing your conditions clearly. For example: "Run this tool if the previous revenue result is empty or equals 0." This approach should allow your workflow to continue even when the initial Google lookup doesn't find revenue information.
Sources: Conditional runs | Documentation | Clay University Conditional Formulas
Channeled
APP
·
·