i need work out total in percentages:

please feel free ask me anymore details.
=sum(fields!outsla.value, "slapriority")/sum(fields!insla.value, "slapriority")*100 had didn't quite go plan. basic knowledge of sorry
sorry post on 1 again.. i'm getting weird percentages. i.e. -200 or -infinity:

to @ report level, can use like:
=1 - (fields!outsla.value / fields!insla.value) i wouldn't multiply 100 in expression, set textbox format property approriate value, e.g. p0.

the above expression assumes detail row. apply @ in header or footer row, use like:
=1 - (sum(fields!outsla.value) / sum(fields!insla.value)) i tried out first formula in basic report:


the results different example, can see underlying figures in last column , why rounded in p0 column.
edit after comment
you can prevent infinity values using iif statements check 0 insla totals, like:
=1 -(iif(sum(fields!insla.value) <> 0 , sum(fields!outsla.value) / sum(fields!insla.value) , 0)) -200% correct value particular row based on calculation: 1 - (3/1) = -2 = -200 %. expect be?
Comments
Post a Comment