FR - departments

[EdLycett]

Hi. I've seen this done before, but now I can't remember how. I'm writing a report where I need each row to be the sum total of a department, where the departments are segment 2, like so:

123 Dept name 1........$$$
234 Dept name 2........$$$

Help? Thanks.

Ed.

 

[DjangMan]

="(ACSEGVAL02 = ""125"")"

in column B assuming the second segment is your department.