RE: “Case when” formula
Hi,
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?
Thanks
Val
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
