topic Re: How add GL_CODE=50010 , into SET expression in App Development

How add GL_CODE=50010 , into SET expression

paulyeo11 — Thu, 21 Apr 2016 01:34:08 GMT

Hi All

My i know how to add GL_CODE=50010 , into below expression :-

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

Paul

Re: How add GL_CODE=50010 , into SET expression

paulyeo11 — Thu, 21 Apr 2016 01:34:55 GMT

My QVF file

Re: How add GL_CODE=50010 , into SET expression

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

May be this:

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))