sum expression

[rafael5958]

I have a straight table with a dimension "name" column and an  expression column. My expression:

count({$<TIPO_TITULARIDADE={'2-Titularidade diferente'},CB-={'TAR','EST'},CAD_NOME-={'NÃO INFORMADO','NA','',NULL}>} distinct ID)

It shows something like:

Name	expression
XXXX	3
AAAAA	3
BBBB	2
DDDD	2
SSSS	2
JJJJJJJ	2
QQQQQQQQQ	1
WWWWW	1
EEEEEE	1
RRRRRRR	1

I need to show ain a text box the sum of this expression, how can I do that?

[rafael5958]

I have a straight table with a dimension "name" column and an  expression column. My expression:

count({$<TIPO_TITULARIDADE={'2-Titularidade diferente'},CB-={'TAR','EST'},CAD_NOME-={'NÃO INFORMADO','NA','',NULL}>} distinct ID)

It shows something like:

Name	expression
XXXX	3
AAAAA	3
BBBB	2
DDDD	2
SSSS	2
JJJJJJJ	2
QQQQQQQQQ	1
WWWWW	1
EEEEEE	1
RRRRRRR	1

I need to show ain a text box the sum of this expression, how can I do that?

[Lisa_P]

Just copy your expression and paste into the Text on the General tab of the Text Object with an = sign in front. Then you can format the Font in Font tab and move the transparency on the General tab to 100%.

[rafael5958]

Its not working, it shows 3, instead of 18.

[StarinieriG · Accepted solution]

Hi,

try with

=Sum(Aggr(count({$<TIPO_TITULARIDADE={'2-Titularidade diferente'},CB-={'TAR','EST'},CAD_NOME-={'NÃO INFORMADO','NA','',NULL}>} distinct ID),Name))