I'm attempting to use a SWITCH statement in order for Report Builder to tell me the premium depending on the level of cover that's selected for this particular part of a policy.
The statement I'm using:
=SWITCH(Fields!Salon_Stock_Equipment_Cover.Value="NOTREQ", "Not Required",
Fields!Salon_Stock_Equipment_Cover.Value="1500", "22.40",
Fields!Salon_Stock_Equipment_Cover.Value="2500", "33.60",
Fields!Salon_Stock_Equipment_Cover.Value="5000", "39.20")
I'm using this in Report Builder.
Aucun commentaire:
Enregistrer un commentaire