DISTINCT application_no

[#1]

can someone give me the correct code to run this, i cannot get it to work

I'm trying to count the amount of apps where the new date and the settlement date the same is

count(DISTINCT application_no, If(new_dates=settled_dates,'Y'))

[simenkg]

You create a flag in your script:

Load *,

           if(new_dates = settled_date,1,0) as ValidFlag

from table...;

then your expression becomes:

count({<ValidFlag={1}>} application_no)

[Anonymous]

Hola,

Use this

count(distinct If(new_dates=settled_dates,application_no))

HTH

[#4]

Hi @Francois

Try this Expression

=Count(DISTINCT If(new_dates = settled_dates, application_no))

[#5]

I like this approch the best as well if its oemthign you going to use more then once. If not, a simple if works fine as well.