jeudi 1 septembre 2016

SSRS Multiple IF SUM based on paramter

I've been struggling with this for a few hours if anyone can help.

=IIF(Parameters!Agent.Value ="Susan Calladine", (Sum(Fields!Susan_Calladine.Value) / Sum(Fields!InvitedToApply.Value), IIF(Parameters!Agent.Value ="Fazaila Pirbhai", (Sum(Fields!Fazaila_Pirbhai.Value) / Sum(Fields!InvitedToApply.Value), IIF(Parameters!Agent.Value ="Claire Willis", (Sum(Fields!Claire_Willis.Value) / Sum(Fields!InvitedToApply.Value),0)))

Basically to calculate specific fields based on the value of the parameter being returend

Aucun commentaire:

Enregistrer un commentaire