Error in syntax

Q&A
, ,
1

image
image867×246 21 KB

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

any help?

2

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

3

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

4

What about

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

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

5

Thanks @ErikG , it’s working

6

Please mark the topic as solved