Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
My QVF
What is the number that you are expecting to see?
Slightly more complicated then I imagined, I will work on this at a later time
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))
Hi Sunny
Can you also give me last month Amount ? it should be 1.413 million.
Paul
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))
I move this to the top , as i am working on this