Good Morning I am looking for help in setting target number based on period filter with value of last year, below is my scenerio I select date from 1st sep to 30th sep i got 2 values day by day - current year sales and last year saleslets say last year total sep is 10,000 & current year so for MTD(19 days) is 6,000now my target is 4,000 for next 11 daysi want daynamic formula how this could be fixed in per day. also i would like to clear based on my period selected the value should be changing. thanks in advance.

Hi, I think a bracket is missing. Try this =-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1)

Forum Discussion

Helper II

7 years ago

Solved

Good Morning

I am looking for help in setting target number based on period filter with value of last year, below is my scenerio

I select date from 1st sep to 30th sep

i got 2 values day by day - current year sales and last year sales

lets say last year total sep is 10,000 &

current year so for MTD(19 days) is 6,000

now my target is 4,000 for next 11 days

i want daynamic formula how this could be fixed in per day.

also i would like to clear based on my period selected the value should be changing.

thanks in advance.