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 |
|
mugen2005
Starting Member
16 Posts |
 Posted - 2011-07-13 : 11:02:49
|
| Goodmorning. I have been running into an issue where I create a table and then want 2 fields calculated. I can create a text box and my expression works fine, however I have multiple rows that need calculated. Could someone point me in the right direction?I have added another column and then placed my expression, it calculated the first row and put that same data in the rest of the rows. here is an examplecol1 col2 col%211 42 19.92212 26 19.94234 12 19.9its not calculating the 2nd and 3rd row. thanks, |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-07-13 : 12:09:17
|
What is your expression. It needs to be something like this:=100*Fields!Col1.Value/Fields!Col2.Value |
 |
|
|
mugen2005
Starting Member
16 Posts |
Posted - 2011-07-13 : 12:22:30
|
| =First(Fields!value1.Value, "dataset1") / first(Fields!value2.Value, "dataset2") then I was going to use the number percent option of the box. this will calculate just 1, not all of the rows |
|
|
|
mugen2005
Starting Member
16 Posts |
Posted - 2011-07-13 : 12:26:28
|
| Sunitabeck, thank you very much. I modified it to your statement and it worked great. thanks again! |
|
|
|
elenalee
Starting Member
2 Posts |
Posted - 2011-07-27 : 01:41:32
|
| thanks for sharing the nice information =============unspammed |
|
|
|
|
|
|
SSRS and computing data from tables