sum of Concat value

[priyarane]

Hi Community,

I wanted to sum up the value from Conact function

Ex:=Concat(DEST_COLUMN,'|')

The value from Above function is =  F_257555885_44

so now I wanted to sum above value ex: sum(F_257555885_44)

Now its cominng like sum(Concat(DEST_COLUMN,'|')) - this how can I execute

like aggr(sum(Concat(DEST_COLUMN,'|'))) - its error any way but I wanted sum up the value

[Clever_Anjos · Accepted solution]

If your expression returns only one value

sum($(=Concat(DEST_COLUMN,'|')))

[swuehl]

You can't use an aggregation inside another aggregation, but more confusing, how do you want to sum F_257555885_44?

Is this a field name?

Maybe like this then

Sum( $(=Concat(DEST_COLUMN,'|') ) )