problem with map title

[zied_ahmed1]

Hello I have this map and i would like when i select one or N department i have the % of the Docs:

I used this but it doesn't work :

=If(GetSelectedCount([DepartementsFR.Name])=0,'',[DepartementsFR.Name]&' : '&

Num(Count({<[DepartementsFR.Name]={"$(=Only([DepartementsFR.Name]))"}>}Docs)/Count(ALL Docs),'###0,00%'))

[zied_ahmed1]

=If(GetSelectedCount([DepartementsFR.Name])=0,'',

GetFieldSelections([DepartementsFR.Name])&' : '& Num(Count(Docs)/Count(total {<[DepartementsFR.Name]>} Docs),'###0,00%')

)

[OmarBenSalem]

the expression u're using?

[zied_ahmed1]

this one :

=If(GetSelectedCount([DepartementsFR.Name])=0,'',

GetFieldSelections([DepartementsFR.Name])&' : '& Num(Count(Docs)/Count(total {<[DepartementsFR.Name]>} Docs),'###0,00%')

)

[OmarBenSalem]

create 2 kpi objects:

1) count(Docs)

2) Count(total {<[DepartementsFR.Name]>} Docs)

at first don't select ANYTHING and tell me what numbers do u see? is it the same in both KPI

then select all departments, and see what happens

then select some departments and see what happens

[zied_ahmed1]

if i don't select anything i have the same value

if i select all departments i have :

if i select two departments :

[OmarBenSalem]

when u do not select anything, u have count(docs) = 1073... ??

[zied_ahmed1]

you mean count (Docs)

Docs = dos_ref_externe this is  just to simplify the name in the topic

[OmarBenSalem]

when u do not select anything, u have count(docs) = 1073... ??

[zied_ahmed1]

yes yes

[OmarBenSalem]

what if u change this:

Count(total {<[DepartementsFR.Name]>} Docs)

to

aggr(Count(total {<[DepartementsFR.Name]>} Docs),[DepartementsFR.Name])