3 Replies Latest reply: Oct 10, 2016 7:30 AM by Yeo Poh sai

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

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

my QVW

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

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

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

Hi Sunny

I think this expression you make are very complicate.

Thank you very much.

Paul