Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
sum(if (claimyear = quoteyear,quotev))
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))