Error in syntax

I’m trying to add % sign to the numeric fields using the concat function
but i’m getting this error

any help?

Looks like only one field (baseflag or Basefield1) is a sum. You have to sum the other field as well.

Basefield1 is a sum of data
baseflag only has 2 numbers 0 and 1
so when Baseflag = 0 then I have to concatenate basefield with %

how do i do it

What about

ifelse(avg(baseflag) = 0, concat(toString(basefield1),"%"),null)

But you know you are creating a string field? Which cant be aggregated!

Thanks @ErikG , it’s working

Please mark the topic as solved