5 Replies Latest reply: Jan 11, 2018 12:26 AM by Kevin yin RSS

    AGGR: return values on one line

    Simon Brulotte

      How do I get values for every line?

      I'm suppose to show for each "Portefeuille" on it's own, the total "Portefeuille" market value.

      The values I get with the expression below are pretty accurate, but they are returned only for one line.

      Total is as follows:

      =sum(aggr(sum({1< VAL_RPT.VAL_DATE = p(Date_calcul), VAL_RPT.PORT_NO = {$(vR_OBL_PORT_NO)} >} VAL_RPT.MKT_VALUE) , VAL_RPT.PORT_CODE))

       

       

      What am I doing wrong?