help with expression

[arusanah]

Hi ,

I am using SVG Map. my requirement is to display count of CUST_ID as % as well as #.  to display % , I'm using following expression.

Num(Count([CUST_ID]) /Count(Distinct([Cust_ID])),'###0')&'%',

But  when I add second measure  count( distinct(CUST_ID) ) to show count as number , my visualization gets disabled.

How can I show both outputs in single SVG . Really appreciate your help!!

[#2]

Num(Count([CUST_ID]) /Count(Distinct([Cust_ID])),'#,##0.00%')

[abhijain]

Hi,

in the map you can simply use the expression as

=num(Count([CUST_ID])/count( all [CUST_ID]),'#,##0.00%')

or

=num(Count([CUST_ID])/count( total [CUST_ID]),'#,##0.00%')

[amit_saini]

Hi,

It has to be:

Num(Count([CUST_ID]) /Count(Distinct([Cust_ID])),'###0%')

Thanks,
AS