Distinct count based on where condition in formaulas Crystal reports

[former_member202170]

HI all

if (country= USA)

then distinct count(states)

when i am doing this formula it it returning all state irrespective  of the condition

Please advise

Thanks

Krishna M

[abhilash_kumar · Accepted solution]

Hi Krishna,

Create a formula with this code:

If {Country} = 'USA' then {State}

Go to 'Insert Summary' > Choose this formula field as the 'Field to summarize' > Choose 'Distinct Count' as the summary operation > Under Summary Location choose Group Footer or Report Footer depending on whether you need a subtotal or grand total.

-Abhilash

[former_member202170 · Accepted solution]

Thanks abhilash

that really helped thank you very much ......