Query YTD Budget Report with multiple ranges

Description of Issue

I am trying to setup YTD Budget Report queries to include multiple ranges in one query

Ex: I have projects 100A through 100J and projects 200A through 200J and want both ranges included on one report

Context
  • YTD Budget Report 
  • GL Segment Find
  • Query Builder
Cause


Resolution

It is not possible to include multiple ranges in one field. The workaround would be to include each individual item separated using the special ' | ' character to form a list.