• Hi

    Why is your filter the filter the field DateLookup ?

    code.sumlookup(lookupset(Fields!DateLookUpKey.Value, Fields!DateLookUpKey.Value,Fields!ActivityTime.Value,"DSData"))

    I think there is easier way to do this

    first if you want to calculate to total for each Agent, you need to do this :

    Sum(Fields!ActivityTime.Value,"AgentName")

    then if you want a ratio, all you need is to do:

    Sum(Fields!Activitytime.value)/Sum(Fields!ActivityTime.Value,"AgentName")

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t: