Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
my QVW
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
Hi Sunny
I think this expression you make are very complicate.
Thank you very much.
Paul