12,694,842 members (33,171 online)
Rate this:
See more:
Am able to format a division of the first part of this expression to two decimal places(below), however am unable able to format it after a multiplication by 100. i want to format to one decimal place the result of multiplication

=formatnumber((SUM(IIf(Fields!Gender.Value = "F",Fields!Eligibleteachers.Value,0)))/SUM(IIf(Fields!Gender.Value = "F",Fields!CountTeachers.Value,0)),2)*100

thanks
Posted 5-Feb-13 4:12am
mayeso656

Rate this:

## Solution 1

Multiply by 100 before taking on the precision.

Try:
`=formatnumber(100*(SUM(IIf(Fields!Gender.Value = "F",Fields!Eligibleteachers.Value,0)))/(SUM(IIf(Fields!Gender.Value = "F",Fields!CountTeachers.Value,0))),1)`
v2
mayeso 5-Feb-13 13:25pm

Thanks Sandeep it worked, great. I also find a way to get what i wanted. I just needed a 3 decimal places,if this is multiplied by 100 it will displace two decimals hence i will have 1 decimal place
Sandeep Mewara 6-Feb-13 0:15am

Welcome.

Top Experts
Last 24hrsThis month
 OriginalGriff 440 ppolymorphe 123 Peter Leow 120 Richard Deeming 90 eddieangel 60
 OriginalGriff 3,243 Peter Leow 2,135 Mika Wendelius 1,743 ppolymorphe 1,519 Jochen Arndt 1,324