2 Replies Latest reply: Nov 28, 2014 6:08 PM by Daniel Sanchez Mendoza RSS

    Conditional Sum

    Daniel Sanchez Mendoza

      Hello Good evening,

       

      I would like to add the value of a field when the condition is valid, I'm using the following formula:

       

      =IF(Sum(Aggr(Sum(Venta),Marca))>Sum(Aggr(Sum({<Tipo={[Medios]}>} Inversion),Marca)),Num(Sum(Aggr(Sum(Venta),Marca)),'$#,##0'))

       

      But that expression gives me the total value of the sell and I would like to see onlye the value of the sell in those cases where the investment in media is grater. And that why I'm using the AGGT at a brand level

       

      Does somebody can help me? Im using the formula in a text object

       

      Thank you