Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I try :-
>=50055 and <=50057
into below expression :-
Money(RangeSum(
Above(RangeSum(Above(Sum({<year, month, GL_CODE = {>=50055 and <=50057}>}[Amount]*1), 0, RowNo()))),
-Sum({<GL_CODE = {>=50055 and <=50057}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {>=50055 and <=50057}>}[Amount]*1), YearMonth)))
, $(vMoneyFormatK_GL))
it return zero.
Paul
Try this:
Money(RangeSum(
Above(RangeSum(Above(Sum({<year, month, GL_CODE = {">=50055<=50057"}>}[Amount]*1), 0, RowNo()))),
-Sum({<GL_CODE = {">=50055<=50057"}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {">=50055<=50057"}>}[Amount]*1), YearMonth)))
, $(vMoneyFormatK_GL))
my QVF
Try this:
Money(RangeSum(
Above(RangeSum(Above(Sum({<year, month, GL_CODE = {">=50055<=50057"}>}[Amount]*1), 0, RowNo()))),
-Sum({<GL_CODE = {">=50055<=50057"}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {">=50055<=50057"}>}[Amount]*1), YearMonth)))
, $(vMoneyFormatK_GL))