Adding an aggr and separate value

[Anonymous]

Hello everyone,

I have an issue where I'm trying to add hours from several teams together, plus hours from one member of a different team.  I'm having trouble getting the correct string to make this happen.  This is my current string:

aggr(Sum({$<TeamOT={'Team A','Team B','Team C','Team D'}>} OTTotal), OTMoyr)

Team E has a member, Anna, that I need to include in the total hours above, but I can't figure out how to do that.  I don't need the rest of Team E, just Anna.  I have an EmpID field with all employee ID's, and I was trying to figure a way to use that in the string, but nothing I tried worked.

Any ideas would be greatly appreciated!

[Gysbert_Wassenaar · Accepted solution]

Something like:

Sum({$<TeamOT={'Team A','Team B','Team C','Team D'}>+<TeamOT={'E'},EmpID={'Anna0123'}>} OTTotal)

[Anonymous]

Worked perfectly!  Thanks,Gysbert!