RE: “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?



ValeriaC Rookie Asked on February 26, 2020 in Random.
Add Comment
2 Answers

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

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.