Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like
=sum({<MonthNameField={'$(vMaxMonthName)'}>}sale)
(removing the equal sign)
You want to just replace the variable with the text, no evaluation needed here.
=sum({<MonthNameField={'$(=vMaxMonthName)'}>}sale)
or
=sum({<MonthNameField={'$(vMaxMonthName)'}>}sale)
or
=sum({<MonthNameField={'$(=Max(MonthNameField))'}>}sale)
or in simple words try like this
sum(if(MonthNameField=$(vMaxMonthName),sale))
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)