We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reporting a sum of one category of candidate expenses

Received Response
23
Views
2
Comments
edited Jan 23, 2018 6:09PM in Reporting and Analytics (TBE) 2 comments

Summary

Reporting a sum of one category of candidate expenses

Content

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!