Need help in Expression (Total)

[#1]

Hi,

The expression which is not working as I am trying to find overall % of each customer, and the expression is as followed and the Tras_No has some duplicate records so when I use TOTAL with Distinct the expression become incorrect, could you please any one suggest workaround for this.

=Count(Distinct(Trs_No))/Count(TOTAL(Distinct(Trans_No)))

Regards

Chriss

[#2]

try this

=Count(Distinct(Trs_No))/Count(TOTAL Distinct(Trans_No))

[#3]

also try this

=Count(Distinct  Trs_No)/Count(TOTAL Distinct Trans_No)

[Anonymous]

Total for each customer would need to have something like this:

    =Count(Distinct(Trs_No))/Count(TOTAL <Customer> (Distinct(Trans_No)))

Alternatively, I think you can also use the Aggr() function like this:

    =Count(Distinct(Trs_No))/Aggr(Count((Distinct(Trans_No))), Customer)

Jonathan