I am doing a report which needs to display a field like
totals/percentages...
the actual data values is something like this
=(Sum(Fields!B.Value))& " / " &
(Sum(Fields!B.Value))/(sum(Fields!A.Value) + sum(Fields!B.Value)+sum(Fields!C.Value)+sum(Fields!D.Value)+sum(Fields!E.Value)+sum(Fields!F.Value))
*100
the problem is sum (fields!B.value) is an integer (sum of students) like 32
and the aggregate value in the denominator is a percentage value (0.014343443%)
I need to approximate the value to 0.014
something like this
totals/percentages... .......32/0,014 instead of 32 / 0.014343443 in the front end of the report properties
Please help
Thanks
Wouldn't math.Round() do the trick? You just want to round the decimal to three decimal places....Right?|||
="32" & " / " & round(0.014343443, 3)
No comments:
Post a Comment