monthly revenue share day wise

[Anonymous]

hi folks,

i have source data for january month.

my requirment is to show it in day wise(31days)

ex: 1-jan   2-jan  3-jan              ..................31-jan

       $ 100    $200    $300                               $ 500

plz find the excel sheet

[swuehl]

It looks like you don't want to use the same amount per day, but maybe a somehow increasing amount.

How do you get the share per day from the monthly value, in your above sample line?

I mean, how did you get the 100, 200, 300, ..., 500? What's the rule behind?

A constant share could be calculated like MonthlyValue / day(monthend(MonthDate))

where MonthDate is any date in that month, e.g. created by makedate(YearField, MonthField).

Hope this helps,

Stefan