Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Fredforfree
Starting Member
49 Posts |
 Posted - 2009-07-15 : 11:29:20
|
| Hi I am working with a visual studio report project that someone else build using a lot of text boxes.How would I multiply results from a text box by 0.54?below is what i attempted=formatpercent(iif(isnothing(reportitems!textbox91.Value),0,(1-(reportitems!textbox15.Value/reportitems!textbox92.Value))/reportitems!textbox91.Value),2)*0.54fredforfreeFred |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-15 : 13:48:12
|
| the expression looks fine. what was the error?only thing is that you dont need to explicitly set format using format percent function. you can just use the standard % format available on cell properties (right click on cell ,click properties go to format tab) |
 |
|
|
|
|
|
Text Box