Date:         Tue, 29 Sep 2009 11:21:28 -0700
Reply-To:     "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject:      Re: Number Conversion into Millions & Calculation based on # of
              days              in a month
Comments: To: Sdlentertd <sdlentertd@GMAIL.COM>
In-Reply-To:  A<ddf8cfc4-21cd-4052-8f02-1ed3d27ab376@m11g2000yqf.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

Hi,


1     round(362507841.7,1e6)/1e6


2)    DaysThisMonth = intnx('month',date(),0,'e')
                      - intnx('month',date(),0,'b') + 1;

so then you could do your formula   $ / DaysThisMonth * 365




Hope this is helpful.


Mark Terjeson
Investment Business Intelligence
Investment Management & Research
Russell Investments
253-439-2367


Russell
Global Leaders in Multi-Manager Investing





-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sdlentertd
Sent: Tuesday, September 29, 2009 10:57 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Number Conversion into Millions & Calculation based on # of
days in a month

1) If I have this number 362507841.7
How can I make it so it only shows 363  (in millions)?

2)Also is there a formula where depending on what month it is, it will
calculate the profit like this:
if it's Jan (31 days) = $ / 31 *365
if it's Feb 2008 (29 days) = $ / 29 *365
if it's Feb 2009 (28 days) = $ / 28 *365
if it's Apr (30 days) = $ / 30 *365


Thank you