Home

RE: Saved Search Query – Actual Cost

Hello,

 

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
Cancel
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?

 

Rgds

Cancel
Rookie Answered on February 7, 2023.
Add Comment
Cancel

Your Answer

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