Expression

[upaliwije]

Hi Friends

count(DISTINCT({<DAY = {">20"}>}[POLICY_No]))

Can some help me to rewrite the above expression in the correct way

[upaliwije]

Hi Ashfaq

sum({<DAY = {">20"}>} distinct [AMOUNT])

The above is working but What I want is count the policy No

[ashfaq_haseeb]

Hi,

Can you please share your sample app.

Regards

ASHFAQ

[upaliwije]

Thanks Ashfaq,

Sorry I am unable to do it

count({<DAY = {">20"}>}[POLICY_NO])

This expression is also working . But the question is when DISTINCT is added to the Expression it is not working

[its_anandrjs]

Can you share some sample data.

[#6]

Hi Upali

Use single quotes instead of double

Count({<DAY = {'>20'}>} DISTINCT  [POLICY_No]  )

Regards

Padma

[swuehl]

What do you mean with 'not working'? What is the result you get and what do you expect?

As mentioned several times before, it would really be helpful if you could post more details about your model and data and what you want to achieve. Best by posting a small sample app that demonstrates your issue.