1 Reply Latest reply: Dec 26, 2013 11:01 AM by Oswaldo Vasquez RSS

    Remove row from TableList

      All,

       

      I build a 'new sheet object' of type Table List. It is populated  with data from Excel. Mistakenly, I am loading the last row, that is Total Revenue, and should be calculated separately but is not an item in the list.

       

      Is it possible to remove an item from the list after the list is built ? On right click, it is possible to remove the whole object, but i cannot find how to eliminate one row.

       

      Regards

        • Re: Remove row from TableList

          Hello,

           

          If you can attach the excel file will be much better but you can try a table list using an expresion and the expresion should be something like this:

           

          If(MyField<>'Total', MyField)

           

          or

           

          If(Len(Trim(MyField))>0, MyField) // If the total row is null or is an space.

           

          Best Regards.