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]

Hello,

Thanks Omar , I need to display the total when i select two departments :

For example :

if i select department 1 = 2% and department2 = 3% i will have 5% like result

[OmarBenSalem]

u mean :

dep1,dep2 = 5%?

[OmarBenSalem]

change it as follow:

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

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

)

[zied_ahmed1]

if i select all departments I will have 100%

if i select  3 departments it gives me the sum of %

[OmarBenSalem]

or try as follow:

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

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

)

[zied_ahmed1]

I select Rôhne = 3,25% and Indre 0,16% I have 3.41 it's good

But i don't know why if i select all departments i don't get 100 %

(I am not selecting any filters )

[OmarBenSalem]

per analogy, this works for me :

if(GetSelectedCount(Dim1)=0 or GetSelectedCount(Dim1)=count(distinct total {1} Dim1)

, 'all : '&num( sum(Expression1) / sum(total {1} Expression1),'# ##0,00%'),   GetFieldSelections(Dim1)&' : '& num( sum(Expression1) / sum(total {1} Expression1),'# ##0,00%'))

[zied_ahmed1]

The only problem now is the total it's 67,16 when i select all departments

[OmarBenSalem]

please show me ur filter bar?

I mean this:

and tell me, what's the exact expression u're using?

[zied_ahmed1]