Forum Discussion

siddhantk989's avatar
siddhantk989
Helper III
9 years ago
Solved

Sum data based on date range

Hi,     I have a date column in my table and a sales column. The dummy data is as follows:   Date          Sales   10/1/2016    500 9/1/2016      200 8/1/2016      600 1/1/2017    100    No...
Need Help
Show and Tell
Tips and Tricks
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    Hi siddhantk989,

     

    It's same result, I just change connection and field name from Order Date-> Date to fit with your file with my column fields. 

     

siddhantk989's avatar
siddhantk989
Helper III
9 years ago

Hi tringuyenminh92,

 

  Thanks for the solution but I dont know wh the above code for fiscal year is working for only 1 year, i.e., it is giving me results only for 2016 for rest all years 2015,2017 and so on I am not getting an data.  IS there any way to resolve this error?

Thanks in advance.

 

Regards,

Siddhant

tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

Hi siddhantk989,

 

I have tried cloned more data for 2015, Fiscal Year is working for serveral years. Could you please describe your expectation as picture or more information? so i could quickly adjust above solution.