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 |
|
midpenntech
Posting Yak Master
137 Posts |
 Posted - 2008-06-06 : 12:22:32
|
| This is a working 12 month intrest equation. I used this for the layout section but I am trying to take this and it gives me the correct values. But what I need to do next is have it sum those values.I tried =SUM( whole expression but that didnt work) you can laugh at me I know but any help would be great!=Switch(Fields!eqprecdt.Value< CDate("1 Jan 2007"),Fields!bookvalue.Value*datediff("d",Now(),#1/1/2007#)* .07/365,Fields!eqprecdt.Value> CDate("1 Jan 2007"), Fields!bookvalue.Value * datediff("d",Now(),Fields!eqprecdt.Value)* .07/365)*-1 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-06 : 12:26:19
|
| May be this:-=SUM(IIF(Fields!eqprecdt.Value< CDate("1 Jan 2007"),Fields!bookvalue.Value*datediff("d",Now(),#1/1/2007#)* .07/365,Fields!bookvalue.Value * datediff("d",Now(),Fields!eqprecdt.Value)* .07/365))*-1 |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-06-06 : 12:26:48
|
| Your expression does not appear to be written in T-SQL.Are you using Microsoft SQL Server?CODO ERGO SUM |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-06 : 12:30:22
|
quote:
Originally posted by Michael Valentine Jones
Your expression does not appear to be written in T-SQL.Are you using Microsoft SQL Server?CODO ERGO SUM
Its actually an expression from SQL Reporting services. I think OP by mistake posted it here. |
|
|
|
midpenntech
Posting Yak Master
137 Posts |
Posted - 2008-06-06 : 12:49:51
|
| That worked great |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-06 : 12:54:41
|
quote:
Originally posted by midpenntech
That worked great
Glad that i could help you out |
|
|
|
|
|
|
|
|
Summing an equation