Month wise sum

[janardhan]

Hi Friends,

This is my expression:  =sum({<BD_Year={'=$(vCurrentYear)'}>}Gross_Premium)

For above expression i am getting values like total sum for 2014. but i need upto this year current month total Gross_Premium.

Please help me

[ajaykumar1]

Try like this;

=sum({<BD_Year={"<=$(=MAX(PERIOD))"}>}Gross_Premium)

In the PERIOD place use your datefield which indicates the upto current month.

Regards,

Ajay

[ashfaq_haseeb · Accepted solution]

Hi,

You need to look at YTD amd MTD.

YTD Expression

=Sum({$<Datefield = {'>$(=Max((YearStart(Today())))) <=$(=Max(Today()))'}>} Sales)

Or

=Sum({$<Datefield = {'>$(=Max((YearStart(Datefield)))) <=$(=Max(Today()))'}>} Sales)

MTD Expression

=Sum({$<Datefield = {'>=$(=Max((MonthStart(Today())))) <=$(=Max(Today()))'}>} Sales)

Or

=Sum({$<Datefield = {'>=$(=Max((MonthStart(Datefield)))) <=$(=Max(Today()))'}>} Sales)

Regards

ASHFAQ

[janardhan]

Thanks Mohammed

[ashfaq_haseeb]

welcome

Regards

ASHFAQ

[qv_testing]

Hi Mohammed,

Same expression how to write in Script level..