J
Jamie
Hi All,
I am working on a project with the financial year being 1
April to 31 March. I need to calculate a percentage of
costs depending on what month of this FY they are
incurred. If costs are incurred in , say, May of the
CURRENT year then charge 10%/12*11, June would be
10%/12*10 etc. However, the month will become irrelevant
in the next FY when the charge for these existing costs
would be 10% and for all new additions of costs in that
new FY would be charged with appropriate proportions like
above.
I have tried with Month and Year functions. But not
getting very accurate as the financial year is different
than normal year. I need to write a formula to place in
the correct column everytime the report is run.Have you
done something like this before? Ideas? Any help would be
much appreciated. Thanks in advance.
I am working on a project with the financial year being 1
April to 31 March. I need to calculate a percentage of
costs depending on what month of this FY they are
incurred. If costs are incurred in , say, May of the
CURRENT year then charge 10%/12*11, June would be
10%/12*10 etc. However, the month will become irrelevant
in the next FY when the charge for these existing costs
would be 10% and for all new additions of costs in that
new FY would be charged with appropriate proportions like
above.
I have tried with Month and Year functions. But not
getting very accurate as the financial year is different
than normal year. I need to write a formula to place in
the correct column everytime the report is run.Have you
done something like this before? Ideas? Any help would be
much appreciated. Thanks in advance.