3 Replies Latest reply: Apr 20, 2016 9:29 PM by Sunny Talwar RSS

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

    PAUL YEO

      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