How can I spread a dollar value over a specified date range?

 

Example

 

$1000 a month for the date range of 10/1/2011-9/30/2013

 

Expectation

 

Oct 2011  Nov 2011  Dec 2011  etc.   Total

1000.00    1000.00    1000.00           24,000.00

 

Thanks!!

 wot i can understand from dis is u jus want to display amount with $ sign for Jan to Sept months...for oct,Nov, Dec you dont want to use $.if i am ryt den you can go for format field option.in dat, customize currency symbol and write condition in dat.

if not den plz specify the condition.

okies..

if you want to display it monthwise then you need to create 12 formulas for dat...one formula for each month.

use 'month' function to get month number...

 

following are the field names i hav used...

Start Date:{StartDate}

End DAte:{EndDate}

Amount:{Amount}

 

in january formula code will be:

if (Month({StartDate}) <= 1 and Month({EndDate}) >= 1) then {Amount} else 0

 

and so on....

then create one formula to get total of all...

code:

{@Jan}+{@Feb}+{@Mar}+{Apr}+{@May}+{@Jun}+{@Jul}+{@Aug}+{@Sept}+{@Oct}+{@Nov}+{@Dec}

 

place each formula next to each oder and u'll get the output...

kindly let me knw if it is useful...okies...al da best!!