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)

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

Hi,

 

When i click on Wedneday, the result of target per day and Sales Diff is the same.  This is what you wanted.

 

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

    Yes excatly but since now all wednesday are covered could you check for sunday if you can see the target would be same as sale difference ? 

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

    Hi,

     

    My formula is correct. The problem seems to be with the relationships.  It will take way too long to study all relationships.  I wont be able to devote so much time.

  • 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.