Isaac Rumbold
05/23/2025, 2:11 PMCeligo AI
05/23/2025, 2:11 PMAI 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:
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:
{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.
******Celigo AI
05/23/2025, 2:11 PMSlack 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
Celigo AI
05/23/2025, 2:11 PM