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 |
|
sajitha
Starting Member
10 Posts |
 Posted - 2014-06-25 : 00:21:49
|
| Hi,I have two stored procedure fields like what I shown below. I just want to multiply each row and get the total sum.Eg: sum = (1*34.8 + 3*78 + 5*199). How I can do it in Crystal report formula? Hour Cost1 34.83 785 199 Thank You |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-08-11 : 11:04:19
|
| Create a new formula and add the below, drop onto report or use with other formulas or fields.//Sum Calc - Formula1*34.8 + 3*78 + 5*199We are the creators of our own reality! |
 |
|
|
|
|
|
Crystal Report formula to calculate sum of product