3 Replies Latest reply on Aug 31, 2018 7:55 AM by Norbert Maijoor

Calculating the FYE by LOD

Hi,

I have the formula below which computes the estimated full year expense.

The problem now is I have data until December but I only want it to compute up to the date selected.

Let's say Total expense is 1000*12/8(August).

Hope you can help.

• 1. Re: Calculating the FYE by LOD

Hi Josephine,

Find my approach as reference below and stored in attached workbook version 10.4 located in the original thread.

1. D1. Year: year([date])

2. D2. min date: {fixed [D1. Year]:min([date])}

3. M1. Count Months: {fixed [D1. Year]:countd([date])}

4. M2. Start Value: if [date]=[D2. min date] then [value] END

5. P1. date Parameter

6. M3. Delta datediff('month',[D2. min date],[P1. date Parameter])+1

7.M4. FYE by LOD:  {sum([M2. Start Value]*[M3. delta])}

8. Drag the required objects to the indicated location and show parameter

Hope it helps,

Regard,

Norbert

1 of 1 people found this helpful
• 2. Re: Calculating the FYE by LOD

thanks you so much

• 3. Re: Calculating the FYE by LOD

Hi Josephine,

You are welcome. Thanks for "the Awards". Much appreciated.

Regards,

Norbert