Forum Discussion

shadi ahmed's avatar
shadi ahmed
Copper Contributor
Mar 29, 2018

Daily Sales Target

HI Guys 

 

i need your help as we have Monty Sales target what i require here :

1- need to divided this monthly to daily target

2- to per as per sales name 

3- to per as per country 

 

can you help me on this 

 

thank in advance 

Formulas and Functions

1 Reply

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Apr 02, 2018

    I think you will need to provide additional information to answer your question.  Can you please provide a sample file with non-sensitive data that has an example of before and after.  

     

    For # 1 you can simply divide the monthly target by 365.25 to get the daily target.....

     

    If we need to use Sales Name or Country Name to split up the data it would be important to see the data structure.

Resources