Set Analysis

[shumailh]

below code is not working, anyone please help

=sum({$<MonthName_ID = {MonthName(MonthEnd(LoadDate-Day(LoadDate)))}>} bal)/(100*1000000)

[nagaiank]

Try the following:

=sum({$<MonthName_ID = {MonthName(LoadDate,-1)}>} bal)/(100*1000000)

Is the format of the fieldvalues in the MonthName_ID field the same as the format returned by MonthName function (i.e., Mmm YYYY)?

[shumailh]

Yes the format is same.

Also I did it like this and its working..

=sum({$<MonthName_ID = {'$(=MonthName(MonthEnd(LoadDate -Day(LoadDate))))'}>} bal)

Thanks,

Shumail