How to remove the condition on If([Exec P&L Level] = 's', '' from my expression ?

[paulyeo11]

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

[sunny_talwar]

Waiting for the sample

[paulyeo11]

My QS file

[sunny_talwar · Accepted solution]

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