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