# SSRS Percentage calculation

Hi

I am using the following expression within SSRS to work out a percentage but I am getting the value of 0.0% when I know that is inncoorect. Could you please take a look at the query below an d tell me where I am going wrong

=iif(Fields!Stage_Name.Value = "Stage 99 - Funded Loan", iif(sum(Fields!Stage_Count.Value) = 0, 0, sum(Fields!Stage_Count.Value)), 0) / iif(Fields!Stage_Name.Value = "Stage 1 - App Started", iif(sum(Fields!Stage_Count.Value) = 0, 0, sum(Fields!Stage_Count.Value)), 0)
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BI ConsultantCommented:
Could you explain your logic in words?  Currently the condition in your numerator is different from the condition in your denominator so you'll never have a x/y division, it will always be either x/0 or 0/y (and x/0 is obviously to be avoided at all cost, I think you'll want to put 1 as default for the denominator).

Experts Exchange Solution brought to you by