Data in text objet

[#1]

I have this chart.

Dimension,

TUK_ID

Expresion

If(count(distinct RAZ_ID)> vNum , Count(distinct RAZ_ID))

Now i need to put in a tex objet a count of difertens RAZ_ID .

i DO.

IF(AGGR(COUNT( DISTINCT RAZ_ID)>vNum), count( disctint RAZ_ID) , TUK_ID)

Please help.

[#2]

if your expression is valid, all you need to do is put in

=IF(AGGR(COUNT( DISTINCT RAZ_ID)>vNum), count( disctint RAZ_ID) , TUK_ID)

[Anonymous]

there are a couple of syntax errors in that expression. but setting them aside, why do you need aggr in a text box? could you give us an example of what the expected output needs to look like? also, what is the expression for vNum?

like Robert said, put an = sign in front of your expression and try a text box...it will tell you exactly where the syntax errors are.

i'm not sure i understand your requirement, but i don't think you are referring to concat.

[maxgro]

try with

=count({$ <TUK_ID={"=count(distinct RAZ_ID)>vNum"}>} DISTINCT RAZ_ID)