Combining set expressions

[Yintak]

Hi

I will like to seek help for this issue:

=AGGR(Concat(DISTINCT [ChargeCode], ', '), [Job Number])

Currently this is what I have for above, I will also like to combine another expression together:

=If(Not Match(ChargeCode, 'AFC'), ChargeCode)

What is the combination that I should use?

Please help, thank you!

[neelamsaroha157 · Accepted solution]

Did you try replacing the [ChargeCode] in first expression with If(Not Match(ChargeCode, 'AFC'), ChargeCode)?

Can you share a sample.

[vishsaggi]

May be this?

=AGGR(Concat(DISTINCT {<ChargeCode -= {'AFC'} >}  [ChargeCode], ', '), [Job Number])

[Yintak]

Thank you Neelam! this is just the result that I needed (: