Income the hard one. - SQL Server Forums

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.

All Forums

Development Tools

Reporting Services Development

Income the hard one.

Author

Topic

midpenntech
Posting Yak Master

137 Posts

Posted - 2008-06-06 : 18:33:10

Ok now this one is a bit trickier I think at least. I need to take +Rental Billing - Depreciation - Repairs - Intrest.

The first 3 are easy to setup but the last one is an equation. see code below if you are able to figure this out.

Rental Billing
=Fields!RentalBilling.Value

Depreciation
=(Fields!Depreciation.Value)/-1

Repairs
=Fields!Repairs.Value

Intrest
=IIF(Fields!eqprecdt.Value< #6/1/2007#,Fields!bookvalue.Value* 0.07,Fields!bookvalue.Value* 0.07 * -1 * datediff("d",#5/31/2008#,Fields!eqprecdt.Value)/365)

Help me lol

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-06 : 18:53:50

This looks like Reporting SErvices, so I'm going to move your thread to that forum. If it's not RS, let me know what it is so I can move it the proper forum.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

midpenntech
Posting Yak Master

137 Posts

Posted - 2008-06-06 : 19:00:22

it is but i get faster responces under the other section. I have posted in here and didnt get answered until i posted under the other section. unless you can answer this?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-07 : 04:16:14

quote:
Originally posted by midpenntech

Ok now this one is a bit trickier I think at least. I need to take +Rental Billing - Depreciation - Repairs - Intrest.

The first 3 are easy to setup but the last one is an equation. see code below if you are able to figure this out.

Rental Billing
=Fields!RentalBilling.Value

Depreciation
=(Fields!Depreciation.Value)/-1

Repairs
=Fields!Repairs.Value

Intrest
=IIF(Fields!eqprecdt.Value< #6/1/2007#,Fields!bookvalue.Value* 0.07,Fields!bookvalue.Value* 0.07 * -1 * datediff("d",#5/31/2008#,Fields!eqprecdt.Value)/365)

Help me lol

may be this

=IIF(Cdate(Fields!eqprecdt.Value)< Cdate('6/1/2007'),Fields!bookvalue.Value* 0.07,Fields!bookvalue.Value* 0.07 * -1 * datediff("d",CDATE(5/31/2008),CDATE(Fields!eqprecdt.Value))/365)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources