February 5, 2016 at 8:40 am
Hi,
I have the following formula and I want to be able to avg the payments if the two values = Dental and Claims. However I am unsure on how to do this.
Below is my code:
=(IIF(Fields!PrimaryGroup.Value = "Caims" AND Fields!Section.Value = "Dental",1,0, (Avg(Fields!Payments.Value))
thank you
February 5, 2016 at 8:59 am
I believe that you're looking for something like this:
=Avg(IIF(Fields!PrimaryGroup.Value = "Caims" AND Fields!Section.Value = "Dental",Fields!Payments.Value,Nothing))
February 5, 2016 at 12:47 pm
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply