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)

Arif270182's avatar
Arif270182
Helper II
7 years ago

Thats the table as you can see negative value is what i need to break in rest of the days 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You already have current and last year sales. so, simple SUM( sales[CYSales]) - SUM( Sales[LYSales]) should give you the expected result.

 

Thanks

Raj

  • Arif270182's avatar
    Arif270182
    Helper II
    7 years ago

    yeah i have already that value which is Sales Difference my point is i want to break that 2,294,091 divide by rest of days  based on filtered date. 

    • 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