sql - Expression to workout in percentages - SSRS -


i need work out total in percentages:

enter image description here

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:

enter image description here

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.

enter image description here

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:

enter image description here

enter image description here

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