Forum Discussion

Arif270182's avatar
Arif270182
Helper II
7 years ago
Solved

Target Setting vs last year

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 ...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    I think a bracket is missing.  Try this

     

    =-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Do you want to divide the difference by the remaining days in sep and display under CY sales column? can you please explain... also can you put the expected result in table format for better understanding?

 

Thanks

Raj

Arif270182's avatar
Arif270182
Helper II
7 years ago

Hi Rajendra 

 

as you see in the picture which i have shared earlier it shows negative value which is difference what i am looking is that based on this value which is my target i want a formula/calculation which shows me based on the remaining days here we have period of september so 11 days 

 

so today the table shows like this

Current year :- 3,214,649

Difference :- 1,931,687

now remaining days for sept is 10 days 

logical answer is 1,931,687/10 = 193,687 - i want this value to be daynamic.

i hope its clear now