Hey,
Is it possible to reference 2 different Lookup Issues list in one rule?
I would like to lookup for 2 lists and divide the size of them by each other.
Thanks,
Nofar
Hi @Nofar Ben Kereth
No, and...You could store the results such as count (size) in a created variable and use it later once you use Lookup Issues again for the second query.
Best regards,Bill
That's what I did but it doesn't seem to work. Adding screenshots
Would you please show what you set as the value for your created variable? Thanks!
You cannot save the entire {{lookupIssues}} result in a created variable... Although I wonder if it was converted to JSON if that was possible. Anyways... You can save the count as that is what you wanted for the division:
{{lookupIssues.size|0}}
Note that I added the default value of zero. That makes it easier to check before trying to divide by zero (or null) later.
And...please note that smart values and functions are case-sensitive, so your division value appears to have the incorrect capitalization for the smart values.
Thanks Bill.
Actually I had a problem with the case sensitive smartvalues.
But I still don't get the right answer.
I get the value of the second list size and not the answer to the division of the 2.
My variable is simple as {{lookupIssues}} (will add the |0, thanks for the tip )
It looks like you're new here. Sign in or register to get started.