3 Replies Latest reply on Jun 29, 2018 11:33 AM by Deepak Rai

# Percent of Whole with Filters

Good Afternoon;

I have a WB where I am trying to Find Percentages but then have them adjust based on a filter for location.  Here is what I have so far:

Internal Referrals =

If [Category] = "Internal Referral" Then [ID]

Else Null

End

External Referrals =

If [Category] = "Internal Referral" Then [ID]

Else Null

End

I have tried the following:

{Fixed (DAtePart('month',[Date])), DAtepart('year',[Date]),[Referred from Location]: CountD([Internal Referrals])}/{Fixed(DAtepart("month",[Date])),DatePart("year",[Date]),[Referred from Location]: (CountD([Internal Referrals]) + CountD([External Referrals]))} :

Won't work at all as there are nulls in the data.

CountD(Internal Referral)/ CountD([External Referral]):

Works until I add other categories to the table- then it gives me a solid 1

I'm sure there is some LOD formula I need to do- however I just can't seem to find it.  Any suggestions would be appreciated.

Please don't ask for WB as I can't due to HIPAA information.

Thanks

• ###### 1. Re: Percent of Whole with Filters

Pl Check This

External Referrals =

If [Category] = "Internal Referral" Then [ID]

Else Null

End

Should it not Be:

External Referrals =

If [Category]<>"Internal Referral" Then [ID]

Else Null

End

Thanks
Deepak

• ###### 2. Re: Percent of Whole with Filters

Pl Check This

External Referrals =

If [Category] = "External Referral" Then [ID]

Else Null

End

It was a quick typo as I copied it.  The answer worked however so I am good to go.

Thank you.