Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

My client needs a report that groups projects in a..

Avatar

Level 1

My client needs a report that groups projects in an expense report based on the existence of a specific expense type in the list of project expenses. Example, projects with Expense Type "Advertising" vs projects that don't have an expense with this type. Has anyone done anything similar?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 10

Hi Mark,

Although I do have a couple of messier suggestions that would yield a single report with groupings (kinda) by the special expense type, I’ll first offer a cleaner approach: create two project reports using EXISTS and NOT EXISTS for the expense type in question, respectively, similar to these examples from @NRYN R - inactive‚ .

Regards,

Doug

Avatar

Level 1

Thank you for helping!

Here is the code I tried. I must be referencing incorrectly. On a Project opject report

EXISTS:A:$$OBJCODE=PROJ

EXISTS:A:ID=FIELD:projectID

EXISTS:A:expense:DE:Expense AOR TA Flag=1

or

EXISTS:A:$$OBJCODE=PROJ

EXISTS:A:ID=FIELD:projectID

EXISTS:A:expense:Expense AOR TA Flag=1

or on an Expense object Report

EXISTS:A:$$OBJCODE=PROJ

EXISTS:A:ID=FIELD:projectID

EXISTS:A:expense:Expense AOR TA Flag=1

or

EXISTS:A:$$OBJCODE=PROJ

EXISTS:A:ID=FIELD:projectID

EXISTS:A:Expense AOR TA Flag=1