May i know how to make it when i not select month = 9 , it will display 447 ? Now display 493

[paulyeo11]

Hi All

=SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)/1000

When month = 9 , it display 447 K is correct.

May i know how to make it when i not select month = 9 , it will display 447 ?

This issue is because my GL data for sept is only available next week Oct 15. So i need to compare base on last month data. that is Aug data not Sept data.

Paul

[paulyeo11]

my QVW

[sunny_talwar · Accepted solution]

May be try this:

=SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=If(Day(Today() + 1) = 1, Max({<sales = {'*'}, year = {$(=Max(year))}>}month), Max({<sales = {'*'}, year = {$(=Max(year))}>}month, 2)))"},eXP={eXP}>}Amount*1)/1000

[paulyeo11]

Hi Sunny

I think this expression you make are very complicate.

Thank you very much.

Paul