Max Month

[#1]

Hi

   Table1:

Date	MAR
2015-03-19	ABC124
2015-02-20	ABC34
2015-03-21	ABC5656

Table2:

Att_Date	LogType	Duration
2015-03-19	Present	450
2015-02-20	Present	621
2015-04-21	Present	458
2015-03-20	Present	420

Based on Max Month available in Table 1 , Duration in Table 2 to be summed up and shown up for the same month ,

In the above ex : Duration of March to be summed up

[Kushal_Chawda]

So do you need only march data in table 2?

[stigchel]

Do you need this in load script or in the front end? In front end you can use

=Sum(if(Month(Att_Date)=$(=Max(Month(Date#(Date,'YYYY-MM-DD')))),Duration))