0 Replies Latest reply: Jul 12, 2016 9:09 AM by Fernando Mercado RSS

    How can I select the date (Year-Month) of the last register of one ID that it´s bigger than 0 (there are registers with zeros).

    Fernando Mercado

      Im trying to show the date of the last register (the variable is AUM) of a specific ID (Rut) with an amount bigger than zero.

       

      debito.png

      This is the original data.

       

      debito.png

       

      Last month with movement (Ultimo Mes con Movimiento) is the variable that I need to create, but that brings mi the bigger Year-Month including the Zeros. How can I introduce that filter? Thanks.