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 

 

would you like to access my laptop to see the file coz i have no idea how i can reduce the table sorry about it