Topic Options
#5321 - 10/25/05 05:47 PM Financial Reporter Code
Ralph Allan Offline
Adagio Virtuoso

Registered: 06/02/04
Posts: 694
Loc: Prince George BC
Is there a code that will return the fiscal period number?

[A client wants a report that will take the budget remaining (annual budget minus YTD actual) and divide it by the number of months remaining to show what they can spend per month for the rest of the fiscal year. Easy formula if I have the fiscal period number.]


Top
#5322 - 10/25/05 06:09 PM Re: Financial Reporter Code
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
=FPERIOD( )
Returns the current fiscal period.
Example:
If fiscal period 9 is the current period, this function:
=FPERIOD( )
would return a value of ?9".

BTW, you can insert this formula in a cell by using the Right Button | Insert Formula | Fiscal Information | Fiscal Period Number

I believe www.greatstatements.com has an example using FPERIOD() that is somewhat like what you want to do, although more complicated.
see: http://www.greatstatements.com/statements/landscapelegal/index.php


Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Softrak Support), 63 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14477 Topics
70707 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31