Set Analysis: use field selection to define set

[martynlloyd]

Hi,

Can anyone help, or point me to a discussion on using one field to subset another field.

I have a list CLAIMYEAR, and I want to select QUOTEYEAR and sum a value QUOTEV

Something like Sum({$<QUOTEYEAR={CLAIMYEAR} >} QUOTEV) ?

I.E. if CLAIMYEAR 2 and 3 are selected, I want the sum of QUOTEV for QUOTEYEAR's 2 & 3...

Best regards,

M.

[ali_hijazi]

sum(if (claimyear = quoteyear,quotev))

[#3]

Assuming that you have a unique identifier for each claim / quote (in this instance I assumed it is called ClaimID)

=sum(aggr(if(CLAIMYEAR = QUOTEYEAR,QUOTEV,0),ClaimID))