Hello All,

in my list report (in cognos 8.3)

i am having

remcount

AmountRemit

above both are measures

now i am having weighted average as (it is a insertable object)WeightAVG= total ([AmountRemit]*[remcount])/total([remcount])

i have year objects as 2008 and 2009 and 2010

in each year i am having below math

if ([remYear] = 2008) THEN ([WeightAVG]) else (null))

it gave me only one value (either 2008 or 2009 or 2010 value)

so i did as below

total (if ([remYear] = 2008) THEN ([WeightAVG]) else (null)))

it gave me irrelevent results

so how can i acheive it

please help me

thanks

asitta