“Case when” formula


I was trying add a formula(number) to save search with CASE WHEN to have as a result the net amount of the quote when STATUS “in discussion” else “0”. I’ve tried several times but I get error, can you please help me?



Rookie Asked on February 26, 2020 in Random.
Add Comment
2 Answer(s)

It needs to match exactly (spaces, casing, etc.) as the status appears when you run the search in the UI.  I do not know the exact status but it should be something like CASE WHEN {status} = ‘In Discussion’ THEN 1 ELSE 0 END

Intermediate Answered on February 26, 2020.
Add Comment

Great!! thanks for your help.

Rookie Answered on February 27, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor