3 Replies Latest reply: Apr 9, 2015 8:56 AM by Kai Hilton-Jones RSS

    Cant figure out why this doesn't work

    Matt Maino

      Hi everyone,

       

      I am trying to add a table to my document that sums all of the loan amounts for a given person and creates a field that contains that sum for each of the rows that is connected to that person. I'm trying to add it to my script but i keep getting an "invalid expression" error. This is what I have:

       

      Tmp:

      LOAD

       

      loan_no,

      sum(amount) as personTotal

       

      RESIDENT ACCOUNTS

      where Employee = 'Non Employee'

      GROUP BY Person;

       

      In the end I would like to have something that looks like this:

       

      loan_noPersonamountpersonTotal
      123Matt500950
      456Matt450950
      789John8001050
      1011John2501050

       

      Is this possible?

       

      Thank you!