Sum Maximum date

[Anonymous]

Dear all.

I am having problems with the following and sincerely I know it is going to be a very simple thing for you but I am not able to solve it.

I have to tables one with Actual Sales with monthly information for several years and i have another table with Budget same format. My applications is showing ok YTD information (currently March) and i can make comparisons between both tables, but the problem is when i try to compare YTD sales vs Full year Budget, meaning, accumulate Sales from Jan 2017 to March 2017 and compared it with the sum of all months of the budget until dec 2017, I am not able to get the later, it always gives me YTD.

Budget date field format is 01/01/2017 (DD/MM/YYYY)

Please help

Thanks

[Anil_Babu_Samineni]

Can you share sample application and expected result, May be

[tyagishaila]

Share sample application, or at least share what expressions you are using to calculate/compare YTD sales vs Full year Budget.

[Anonymous]

Hi Anil, Shaila

the expressions i am using are:

=Sum({<SalesYear=,SalesMonth=>}Budget for budget

and

=sum(AMOUNT) for sales

both are OK for YTD information (as of Mach), but i want budget expression to give the FY2017 sum.

these are the tables i am using.

Thanks again

Budget Table					Sales Table
Country	BudgetDate	Budget			SalesDate		YTD Sales	9.947.851,5
UK	01/01/2017	155.584,8			01/01/2016	3.104.235,0	YTD Budget	311.169,6
UK	01/02/2017	155.584,8			01/02/2016	9.655.618,1
UK	01/03/2017	155.584,8			01/03/2016	6.025.539,6	FY Budget	2.022.602,0
UK	01/04/2017	155.584,8			01/04/2016	4.812.765,2
UK	01/05/2017	155.584,8			01/05/2016	3.623.366,5
UK	01/06/2017	155.584,8			01/06/2016	26.065.827,1
UK	01/07/2017	155.584,8			01/07/2016	6.497.854,9
UK	01/08/2017	155.584,8			01/08/2016	6.196.406,6
UK	01/09/2017	155.584,8			01/09/2016	6.812.497,5
UK	01/10/2017	155.584,8			01/10/2016	4.571.271,9
UK	01/11/2017	155.584,8			01/11/2016	18.364.938,7
UK	01/12/2017	155.584,8			01/12/2016	15.890.171,0
UK	01/12/2017	155.584,8			01/01/2017	3.325.980,0
					01/01/2017	6,621,871,5

[ahaahaaha]

Hi Victor,

May be just remove the {<SalesYear=,SalesMonth=>} selection exception for the budget field?

Regards,

Andrey