RE: Saved Search Query – Actual Cost



I am trying to get search which will pull actual cost against revenue through saved searches. When I put in the code below, I am getting an error message – any suggestions please?

  1. Under the Results tab, set the following Columns:

    • Formula (Currency) | Sum | Case when {‌accounttype} = ‘Income’ then {‌grossamount} else 0 end | Total Revenue
GRAMOR Rookie Asked on February 1, 2023 in Saved Searches.
Add Comment
2 Answers

Hi James,

Thanks for the help, but I can’t replicate your solution. Sadly even if I manually type this into the field I still get “ERROR: Field Not Found” any other thoughts?



Rookie Answered on February 7, 2023.
Add Comment

Your Answer

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