topic Re: How to get Last year same period Stock Amount ? in App Development

How to get Last year same period Stock Amount ?

paulyeo11 — Thu, 21 Apr 2016 01:51:39 GMT

Hi All

May i know how to change the below SET expression , to get Last year same period Stock Amount ?

Money(RangeSum(
Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),
-Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth)))
, $(vMoneyFormatK_GL))

So that my Table 2 have one more column display LY same period stock amount.

Paul

Re: How to get Last year same period Stock Amount ?

paulyeo11 — Thu, 21 Apr 2016 01:52:24 GMT

My QVF

Re: How to get Last year same period Stock Amount ?

sunny_talwar — Thu, 21 Apr 2016 01:55:39 GMT

What is the number that you are expecting to see?

Re: How to get Last year same period Stock Amount ?

paulyeo11 — Thu, 21 Apr 2016 02:02:12 GMT

Re: How to get Last year same period Stock Amount ?

sunny_talwar — Thu, 21 Apr 2016 02:12:24 GMT

Slightly more complicated then I imagined, I will work on this at a later time

Re: How to get Last year same period Stock Amount ?

sunny_talwar — Thu, 21 Apr 2016 03:02:12 GMT

Try this:

Money(RangeSum(Sum({<year, month, GL_CODE = {50010}>}[Amount]*-1),

Sum({<year, month, GL_CODE = {50010}, YearMonth = {"=YearMonth > AddYears(Max(TOTAL YearMonth), -1) and YearMonth <= Max(TOTAL YearMonth)"}>}[Amount]*1))

, $(vMoneyFormatK_GL))

Re: How to get Last year same period Stock Amount ?

paulyeo11 — Thu, 21 Apr 2016 04:22:22 GMT

Hi Sunny

Can you also give me last month Amount ? it should be 1.413 million.

Paul

Re: How to get Last year same period Stock Amount ?

sunny_talwar — Thu, 21 Apr 2016 08:06:21 GMT

Try this:

Money(RangeSum(Sum({<year, month, GL_CODE = {50010}>}[Amount]*-1),

Sum({<year, month, GL_CODE = {50010}, YearMonth = {"=YearMonth > AddMonths(Max(TOTAL YearMonth), -1) and YearMonth <= Max(TOTAL YearMonth)"}>}[Amount]*1))

, $(vMoneyFormatK_GL))

Re: How to get Last year same period Stock Amount ?

paulyeo11 — Thu, 02 Jun 2016 07:33:23 GMT

I move this to the top , as i am working on this