CurrentMonthSales

[vanderson009]

Hello Community,

I am using this expression to retrive current month sales

=sum({<MonthNameField={'=$(vMaxMonthName)'}>}sale)

my MonthNameField contains MonthName Data and current Data is Jan-14

my variable vMaxMonthName is also store Jan-14

but still i am unable to calculate Current Month Sales

Please need help.

- Thanks and Regards,

Villyee

[swuehl]

Try like

=sum({<MonthNameField={'$(vMaxMonthName)'}>}sale)

(removing the equal sign)

You want to just replace the variable with the text, no evaluation needed here.

[MK_QSL]

=sum({<MonthNameField={'$(=vMaxMonthName)'}>}sale)

or

=sum({<MonthNameField={'$(vMaxMonthName)'}>}sale)

or

=sum({<MonthNameField={'$(=Max(MonthNameField))'}>}sale)

[kushalthakral]

or in simple words try like this

sum(if(MonthNameField=$(vMaxMonthName),sale))

[its_anandrjs]

In very simple way you can write

=sum({<MonthNameField={'$(=Max(MonthNameField))'}>}sale)

Or

=sum({<MonthNameField={"$(=Max(MonthNameField))"}>}sale)

And if you use variable

=sum({<MonthNameField={'$(vMaxMonthName)'}>} sale)

Or

=sum({<MonthNameField={"$(vMaxMonthName)"}>} sale)