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)

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Your question is not clear.

Arif270182's avatar
Arif270182
Helper II
7 years ago

Hello 

 

Apologies if it wasn't clear 

 

what i mean now that we got accurate value for "target per day" i am looking ahead to how i could break this number more accurate based weekdays

so based on snaps shared in previous message we see our "target per day" is 197,991 (thats for the rest of the days to close september - which are empty cells of table) i hope this is clear.

 

now here is what i am looking for so 24th sep is Monday, 25th Tues, 26th Wed and so on, 

so incase if i select/filter monday then based on remaining monday it shall give me "target per day" only for monday so like in the snap i had shared i have selected Wednesday so you can notice there is one empty cell in table i.e. 26th september so if you notice the value of "target per day" is showing 19,212 which should not be correct logically.

 

As per my understanding it should give me value of sales difference in this case coz we have only 1 wednesday.

 

i hope i have ellobrated it clear enough to make you understand if not then let me know if i could reach you in other mode of communication.

 

thank you