Set Analysis

[#1]

Hi All,

I want to get the count based on the premium value. If I am having a table like below

Policy	Premium
P1	100
P5	100
P2	200
P8	200
P9	200
P3	300
P7	300
P4	400
P10	400
P6	500

Tried the below in set analysis did not work. Please advise.

if([Premium Band]='0 - 200',Count({$< Premium= {">=0 <200"}>} DISTINCT Policy))

The Premium Band is the field created speratly.

Thanks,

Sijo

[marcus_malinow]

Hi Sijo,

try adding your [Premium Band] condition to your set.

Count({$<[Premium Band]={'0 - 200'}, Premium={">=0<200"}>} DISTINCT Policy)

Marcus