7 Replies Latest reply: Jul 9, 2018 7:16 AM by Sunny Talwar RSS

    Expression error

    sakshi kaul

      Hi

      This below expression for cumulative sales is not giving correct result

      =BELOW(TOTAL(RangeSum(Above(TOTAL Sum( { <Sold_Date= {">=$(From)<=$(To)"} >} [sales price]* quantity_sold)-sum({ <Sold_Date= {">=$(From)<=$(To)"}>}[sales price]* quantity_returns)) , 0, RowNo(TOTAL))))

      Paint1.png