E
evandavies75
I create a monthly report for my client showing how many hours (and
the dollar value of those hours) have been used in that month as well
as where we stand year-to-date. There are 26 line items representing
separate projects in the body of the report. Based on the fee my
company is paid for each project, I have created two columns on the
right-hand-side of the report to show the percentage of total hours
the client has used to date and the remaining hours the client has
available for the remainder of the year.
This is all background to give the context of the document. My focus
is on two formulas I have created to appear beneath the body of the
report. One formula calculates and displays what I call "fee
performance y-t-d." The formula is: ="Fee Performance Y-T-D "&TEXT(I30/
C30*(MONTH(F3))),"0%"). Where I30 = total dollar amount of the fee
used to date for all projects; C30 = the total monthly fee payment for
all projects; F3 = the current month that's entered at the top of the
report.
Next to this I have another line of text that shows the fee
performance for just that month. The formula is "Fee Performance for
Month "&TEXT((G30/C30),"0%). So here is the crux of my question. I
want to customize this statement so on each monthly report the actual
month appears as text rather than the generic "fee performance for
month."
How can alter the formula so the statement reads, for example, "Fee
Performance for April 38%" ?
the dollar value of those hours) have been used in that month as well
as where we stand year-to-date. There are 26 line items representing
separate projects in the body of the report. Based on the fee my
company is paid for each project, I have created two columns on the
right-hand-side of the report to show the percentage of total hours
the client has used to date and the remaining hours the client has
available for the remainder of the year.
This is all background to give the context of the document. My focus
is on two formulas I have created to appear beneath the body of the
report. One formula calculates and displays what I call "fee
performance y-t-d." The formula is: ="Fee Performance Y-T-D "&TEXT(I30/
C30*(MONTH(F3))),"0%"). Where I30 = total dollar amount of the fee
used to date for all projects; C30 = the total monthly fee payment for
all projects; F3 = the current month that's entered at the top of the
report.
Next to this I have another line of text that shows the fee
performance for just that month. The formula is "Fee Performance for
Month "&TEXT((G30/C30),"0%). So here is the crux of my question. I
want to customize this statement so on each monthly report the actual
month appears as text rather than the generic "fee performance for
month."
How can alter the formula so the statement reads, for example, "Fee
Performance for April 38%" ?