Set Analysis AND Issue

[Domino3145]

Hi

I'm having a strange issue with my set analysis where suddenly my code becomes unresponsive to changing selections in the field [Policy Claim Paid Amount] when I try and use this AND condition.

The below line works perfectly, changing depending on selections in all fields, including when selections are made in [Policy Claim Paid Amount]. It just counts how many claims have been paid with the type 'TIEUK... etc.'

COUNT({$<Type={'TIEUKWeddingClaimsLossDate'}>}[Policy Claim Paid Amount])

However, the below line only mostly works, I am trying to count how many values of [Policy Claim Paid Amount] with the type 'TIEUK... etc.' are negative. This is responsive to all selections except for the field [Policy Claim Paid Amount] itself, for instance if I select "£50" suddenly all my graphs change accordingly EXCEPT this one line, in which the count stays the same.

COUNT({$<Type={'TIEUKWeddingClaimsLossDate'}, [Policy Claim Paid Amount]={"<0"}>}[Policy Claim Paid Amount])

What am I doing wrong here? Does anyone have any idea why suddenly I cant filter by [Policy Claim Paid Amount] anymore?

[Oleg_Troyansky · Accepted solution]

Hi there,

By definition, Set Analysis modifiers ("filters") that use the equals sign, replace user selections in the specified fields. So, when your Set Analysis condition includes the following modifier:

[Policy Claim Paid Amount]={"<0"}

that means that any user selections in the field [Policy Claim Paid Amount] will be replaced with the specified selection (negative numbers).

You could use Boolean operators such as +, -, or * to augment user selections in the same field. For example:

[Policy Claim Paid Amount] *= {"<0"}

This modifier will select the intersection of user selections and the specified condition. In your example, if you select 50 in the amount field, the intersection of that selection and the condition that selects negative numbers, is an empty set. However, if you selected -50, you'd get a count of all amounts that are equal to -50.

I hope this helps,