SUM with SubField in SetExpression

[gf]

Hello all,

Why is this expression wrong?

=NUM(SUM( {$<TextG1 = {"=subfield(Concat(distinct TextG1,','),',',1)"} , JAHR={'2017'}>} SALDO),'#.###,##'))

Thanks in advance!

[marcus_sommer · Accepted solution]

Try this:

SUM( {$<TextG1 = {'$(=subfield(Concat(distinct TextG1,','),',',1))'} , JAHR={'2017'}>} SALDO)

- Marcus

[gf]

Thank you very much Marcus!

Regards,
Gf