How to use set analysis

[#1]

Hello

I use the following set analysis in an expression, but it doesn't work.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"},[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

It only gives as result the records : Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}

Can somebody help me ?

Thanks in advance

Marc

[#2]

Hi

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

+

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

[#3]

Hi

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

+

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

[#4]

Hi

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

+

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

[#5]

Hi

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

+

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

[#6]

Hi

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

+

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

[#7]

Hi

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

+

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

[PrashantSangle]

Hi,

If you get correct answer then close thread by mark as correct answer and helpful answer.

Regards,

[#9]

Hello

Thank you, but my question is “How do I close the thread ?”

Thanks in advance

Marc

[PrashantSangle]

Hi,

Select those answer which help you to solve the problem as Correct answer or Helpful answer.

If Select as Correct answer then your conversation is consider as closed.

Regards,

[#11]

Hello

It is done, thanks.

Marc