Reporting a sum of one category of candidate expenses
SummaryReporting a sum of one category of candidate expenses
I'm working on a report that will tell me what we've paid for relocation expenses by employee group. Some candidates have multiple entries for relocation. How can I sum the relocation expenses per candidate per requisition and keep the data in a format that I can export into excel so I can further manipulate the data?
I was thinking that I could create an expression that would calculate a sum of expense category = relocation. Maybe an IF statement?
If category = relocation then sum category
This is as far as I got: