BI Publisher conditional grouping one group only

Chris E

Summary

Break one business unit by department depending on certain account ranges

Content

Pleaee help, I'm a novice BI creator.

I need to split group in report depending on range value. The report already has 5 groups, I need the top level group to split when a certain business unit and department value range of values. The split only will happen with one business unit. 

Report is run from PSoft query based on run control in Peoplesoft.

What's the best way to achieve this?

 

Code Snippet

Range Value:
if (DEPTID >= '6325000' and deptid <= '6328000' then
'Funky'
else
''

Chris E

Will not allow deletion of post. There have been no replies for solution, so post is useless and taking up space. I'm looking for solutions, not unanswered questions.

Ron-92886

Wouldn't a IF statement after the first for-each do the trick?