Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
May i know how to remove the condition on If([Exec P&L Level] = 's', '' from below expression ?:-
Money(RangeSum( Above(RangeSum(Above(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*1)), 0, RowNo())))
, -Sum(TOTAL Aggr(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*1)), YearMonth))) , $(vMoneyFormatK_GL))
Paul
This seems to be working in QV, can your try in QS
=Money(RangeSum(
Above(RangeSum(Above(Sum({<year, month>}[Amount]*-1), 0, RowNo()))),
-Sum(TOTAL Aggr(Sum({<year, month>}[Amount]*-1), YearMonth)))
, $(vMoneyFormatK_GL))
Seems to be working in QS for the selections you have, not sure what happens for other selections
Waiting for the sample
My QS file
This seems to be working in QV, can your try in QS
=Money(RangeSum(
Above(RangeSum(Above(Sum({<year, month>}[Amount]*-1), 0, RowNo()))),
-Sum(TOTAL Aggr(Sum({<year, month>}[Amount]*-1), YearMonth)))
, $(vMoneyFormatK_GL))
Seems to be working in QS for the selections you have, not sure what happens for other selections