Conditional Expression

[gfisch13]

Hi - I'm having an issue understanding how/when to use functions.  I'm trying to count distinct case numbers where:

Case Type = Claim AND Amount_At_Risk >= 250,000

Can anyone suggest an expression to use??   Also, is there any documentation to research for expressions so I can learn from a good starting point???

Thanks!

[miguelbraga]

Here is an expression you can use:

If by 250,000 you meant 250:

Count({$<Type = 'Claim', Amount_At_Risk = {'>=250)'}>} distinct [you desired dimention])

If not, you meant 250000:

Count({$<Type = 'Claim', Amount_At_Risk = {'>=250000)'}>} distinct [you desired dimention])

PS: Replace [you desired dimention] by your field for example:

Count({$<Type = 'Claim', Amount_At_Risk = {'>=250000)'}>} distinct ID_Number)

Hope this serves you

Regards,

MB

[trdandamudi]

May be as below:

Count( {<Case_Type = {'Claim'}, Amount_At_Risk = {'>=250000'}>} Distinct CaseNumber)

Note: I updated as Sunny mentioned below:

Replace CaseNumber field with your field name,

[sunny_talwar]

I think you mean this

Count( {<Case_Type = {'Claim'}, Amount_At_Risk = {'>=250000'}>} Distinct CaseNumber)

[gfisch13]

This is what the expression builder is showing.  It accepted your expression as shown above but as you can see there is nothing showing on the chart.  Which part is the set modifier?

[trdandamudi]

Yes.... I will update the post.... Thanks.... 

[trdandamudi]

Can you please share a small sample......

[sunny_talwar]

I think you missed an equal sign after AMOUNT_AT_RISK_USD field

[sunny_talwar · Accepted solution]

Count( {<Case_Type = {'Claim'}, Amount_At_Risk = {'>=250000'}>} Distinct CaseNumber)

[gfisch13]

Perfect, such a small detail makes a difference.  Where would you suggest I go to learn about sets, other expressions.  This is confusing!!!