Forum Discussion

Arif270182's avatar
Arif270182
Icon for Helper II rankHelper 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)

Arif270182's avatar
Arif270182
Icon for Helper II rankHelper II
7 years ago

Hi Ashish

 

Thank you, i really appreciate the effort you put for me to understand it, just i would like to know a general or logic how it would work if possible to share

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

I really cannot say.  It's too large a model.