3 Replies Latest reply: Jul 27, 2016 5:21 AM by PAUL YEO RSS

    How to break the complex expression into 2 part ?

    PAUL YEO

      Hi All

       

       

      I have below expression from sunny working fine . May i know how to break the below expression into 2 part ?

       

       

      (RangeSum(Above(RangeSum

      (Above(

      Sum

      (

      {

      <

      year, month, aP={aP}

      >

      }

      [Amount]*-1), 0, RowNo()))),

      -

      Sum(

      {

      <

      aP={aP}>

      }

      TOTAL Aggr(Sum(

      {

      <

      year, month, aP={aP}

      >

      }

      [Amount]*-1), YearMonth

      ))))

       

      So that i can make it as load script.

       

      Paul