Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
according to me your requirement is to get count of values has (code 4,and >75000)
+(code 3,and >22000)
so its best to go with
=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)
+
Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)