How to wtire a formula that compares two number fi...
# ask-stanley-ai
i
How to wtire a formula that compares two number fields
c
AI generated answer (using internal Slack threads):
To write a formula that compares two number fields, you can use a CASE statement in a formula field. Here is an example:
Copy code
CASE WHEN {field1} = {field2} THEN 'Yes' ELSE 'No' END
This formula will return 'Yes' if the two fields are equal and 'No' if they are not. If you want to show the difference between two numeric fields, you can simply subtract one field from the other in a numeric formula field. Here is an example:
Copy code
{field1} - {field2}
This formula will return the difference between the values of field1 and field2. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.839904249
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.832734942
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830222368
Please provide your feedback on this answer.