I know I ask far more than I can return so thank you all for your help.

I have a formula ({Table.A} – {Table.B})/{table.B} to find the percentage of increase or decrease between these two tables. The problem in Table.B has instances where the value is “0”. This still may result in an increased value so I don’t want do a simple If/Then to force a “0”.

I tried this formula but received an error. I’m sure it’s because I am not nesting right.

If {UCR_Code__1.2014 YTD} and {UCR_Code__1.2013PYTD} = 0 then

"0"

If {UCR_Code__1.2013PYTD}= 0 then

{UCR_Code__1.2014 YTD} * 100,

Else ({UCR_Code__1.2014 YTD} – {UCR_Code__1.2013PYTD})/{UCR_Code__1.2013PYTD}