Dividing a Number by 12 and showing it proportionally over 12 Months

[markcobb]

I am trying to create a report where by I have a Start Date and a Total Value fields. The Start Date denotes the Contract Start Date and I want to spread this evenly over a 12 month period. For example I want to have a Contract that starts on 01/03/2002 and ends on 28/02/2003 for £10000.00. In each column (using a cross tab) I would want to show 833.33

Anyone have any ideas at all.

 

[dgillz]

create 2 formulas:

One = round({field}/12,2)
two= {Field}-(round({field}/12,2)*11)

Use formula one for the first 11 columns and formula two for coulun 12. Any rounding will be put in column 12 with this method. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[markcobb]

Sorry to appear daft...but I am not sure I understand. Are you saying I should use these formulas on the Date field or the Total field