need this as a %

[#1]

Anybody help us get the following expression to show as a % on a straight table?

100 - (Count (if (Ethnicity = 'NULL',[Client No]))/Count (Ethnicity))

the usual, '#.##' or changing number format doesn't work.

Chris

[sunny_talwar · Accepted solution]

May be this:

Num(1 - (Count({<Ethnicity = {'NULL', 'Refused'}>} Ethnicity)/Count (Ethnicity)), '##.##%')

[sunny_talwar]

Kush don't you think that this can be a set analysis expression rather than if statement?

[Kushal_Chawda]

Yeah. it is better with set analysis, but this should also work

[sunny_talwar]

Agreed

[MK_QSL]

chris.fray  It's more than 3 hours, you are getting replies on this post which I think not much difficult.

It's always a best option to provide a sample app to get a quick answer.