7 Replies Latest reply: Nov 7, 2012 4:04 PM by Fernan Gonzalez RSS

    how to get a specific value on expression

      HI

       

      I have a chart with balance by rowid for specific client

       

      ie.

       

      client    transid   balance     rowid

      00          111             0          1

      00          212             5          2

      00          301             8          3

      00          432             5          4

      00          523             0          5

      01          645             5          6

      01          767            10         7

      01          843            15        8

      01          934            20        9

      01          102            15        10

      01          115            18        11

      02          128            20        12

      02          130             5          13

       

      I used a function aggr in expression to get last rowid for a specific client but i need to get balance for this rowid

       

      aggr( max(ROWID), Client))

       

      This function return for client 00 the rowid= 5, i need balance = 0

       

      How i can get this?