Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%'))
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
u mean :
dep1,dep2 = 5%?
change it as follow:
=If(GetSelectedCount([DepartementsFR.Name])=0,'',
GetFieldSelections([DepartementsFR.Name])&' : '& Num(Count(Docs)/Count(total {1} Docs),'###0,00%')
)
if i select all departments I will have 100%
if i select 3 departments it gives me the sum of %
or try as follow:
=If(GetSelectedCount([DepartementsFR.Name])=0,'',
GetFieldSelections([DepartementsFR.Name])&' : '& Num(Count(Docs)/Count(total {<[DepartementsFR.Name]>} Docs),'###0,00%')
)
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 )
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%'))
The only problem now is the total it's 67,16 when i select all departments
please show me ur filter bar?
I mean this:
and tell me, what's the exact expression u're using?