0 Replies Latest reply: Jul 18, 2012 12:13 PM by Pablo Gálvez RSS

    Function Match()

    Pablo Gálvez

      Hello! I have I table like this

       

      Sect     Com1   Com 2 

        1           4          23

        2           3          2

        5           1          32

        6           10        13

        4          67        45

        3          34        23

       

      But de Dimension Sect is Dimenssion Calculated Like this:

       

      =if(aggr(sum(date(vDate)-Field1),Field2)= vDate, Today,

      if(aggr(sum(date(vDate)-Field1),Field2)>=1 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=30, '3',

      if(aggr(sum(date(vDate)-Field1),Field2)>=31 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=60, '31',

      if(aggr(sum(date(vDate)-Field1),Field2)>=61 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=90, '23'))))

       

      I know that in tab order you can use the function Match() like

       

      =Match(Dimenssion,'Today','3',23','31')

       

      But How can should be when the dimenssion is calculated?

       

      Thanks