i trying build ssrs report sums value gift.amount 2 different datasets. first dataset calculating fine, , second dataset using lookup function, doesn't seem calculating properly. grouping on fund_category, using =sum(lookup(fields!fund_category.value,fields!fund_category.value, fields!gift_amount.value, "dataset2")) , total calculation incorrect. datasets have exact same query.
Comments
Post a Comment