How to pro rate Fixed Budget Amount daily? Help!!

I need assistance to prorate my fixed budget Monthly Amount. If I run report first week of the month. How do l use variable to look at my calendar date and divide the fixed buget amount accordingly to reflect To date Budget Amount?

E.g. If my Budget Amount is \$4500 and we have 30days in April. When l run report on day 10 in April. I need variable to calculate \$4500/30 *10. If report run Day 17 then it should be \$4500/30 * 17.

All help appreciated

10|10000 characters needed characters exceeded

Related questions

• Former Member
Posted on Sep 20, 2016 at 04:16 AM

Hello Shila,

You can use below.

=([BudgetAmount]/DayNumberOfMonth(LastDayOfMonth(CurrentDate())))*DayNumberOfMonth(CurrentDate())

Regards

Niraj

10|10000 characters needed characters exceeded
• Former Member Shila Brown

In that case use below.

=If UserResponse("PromptText")=FormatDate(CurrentDate();"Mmm yyyy") Then ([BudgetAmount]/DayNumberOfMonth(LastDayOfMonth(CurrentDate())))*DayNumberOfMonth(CurrentDate())

Else [BudgetAmount]

Regards

Niraj