topic Current Month Previous year in App Development

Current Month Previous year

dafnis14 — Thu, 08 Nov 2018 13:18:05 GMT

Hi,

I wonder why using the current month doesn't work for previous year:

sum({<Month={'$(vMaxMonth)'}, Year={'$(vPreviosYear)'}>} LineTotal)

Only a date range:

sum({<Date= {">=$(vMonthStartPrevYear) <=$(vMonthEndPrevYear)"}, Year=,Month=, Date=>} LineTotal)

Thanks!

Re: Current Month Previous year

sunny_talwar — Thu, 08 Nov 2018 13:25:20 GMT

May be you have to ignore selection in Year, Month and Date just like your other expression

Sum({<Month={'$(vMaxMonth)'}, Year={'$(vPreviosYear)'}, Year, Month, Date>} LineTotal)

Re: Current Month Previous year

dafnis14 — Thu, 08 Nov 2018 13:45:15 GMT

Hi Sunny,

It doesn't help..

even writing the expression as follows gives a wrong result:

sum({<Month={'10'}, Year={'2017'},Year=,Month=,Date=>} LineTotal)

I'm getting a much larger sum then expected, but can't figure what it is..:-(

Thanks!

Re: Current Month Previous year

sunny_talwar — Thu, 08 Nov 2018 13:50:11 GMT

Huh!! even the hard coding gives the incorrect result? That is very strange.... also, I made a mistake in my previous expression... Year and Month should not repeat... can you try this and see if this works

Sum({<Month={'10'}, Year={'2017'}, Date>} LineTotal)

Re: Current Month Previous year

dafnis14 — Thu, 08 Nov 2018 13:59:06 GMT

Great, Sonny!

"Year and Month should not repeat" - made my day!

Thank you!