reporting services - Subtract two columns in two different tablix SSRS 2005 -

i have 2 tablix in report(ssrs 2005). want subtract 2 different columns. use following :

=math.round(sum(fields!ly_sales.value, "ds1"))-math.round(sum(fields!ty_sales.value, "ds2")) 

for display of columns use following:

=format(math.round(sum(fields!ly_sales.value)),"#,##") =format(math.round(sum(fields!ty_sales.value)),"#,##") 

sample display value : seperate columns : ly_sales - 40,240 ty_sales - 86,983 difference value : -47406

this not show actual difference, there difference in value. want remove '-' symbol if it's negative want show difference. how can resolve can me this...

thanks in advance ..

this not show actual difference, there difference in value.

i've done testing , not reproduce issue.
if testing in bids, advise delete cache potential root cause.

also want remove '-' symbol if it's negative want show difference.

you can abs() function, returns absolute value of input.

your original expression become:

=abs(round(sum(fields!ly_sales.value, "ds1"))-round(sum(fields!ty_sales.value, "ds2")))