Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sameperiodlastyear Sum issue

Hi All,   I have a problem with "Total" Previous Year sales.  I have a specific time frame - from 1 to 16th of Jan. When I want to see a result on customer level I see actuals for current month, b...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous .

     

    Thank you very much for your reply and your desire to help.

    I think I found core issue - my calendar. In table with data - data is input on Sunday's (for example 1/5/2020,1/12/2020,1/19/2020 etc.). I made a calendar as (min,max) from data table. Now I changed (min,max) into (2019,2020). Basicly now, I don't have GAPs in my calendar books and now everything seems to be working.

     

    I think that was main reason of the issue.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

That's wierd. Can you share some sample data and the expected result to have a clear understanding of your question? It will help me to do tests. You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

 

Best Regards,

Yuna

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous .

 

Thank you very much for your reply and your desire to help.

I think I found core issue - my calendar. In table with data - data is input on Sunday's (for example 1/5/2020,1/12/2020,1/19/2020 etc.). I made a calendar as (min,max) from data table. Now I changed (min,max) into (2019,2020). Basicly now, I don't have GAPs in my calendar books and now everything seems to be working.

 

I think that was main reason of the issue.