3 Replies Latest reply on May 10, 2013 11:57 AM by Phillip Burger

    Project expressions must be scalar Error Message

    Phillip Burger

      I'm using a live connection to a SQL Server DB.  I have two calculated fields and then a third field that is the first calculated field divided by the second. I'm using the RAWSQLAGG_SUM() function as I couldn't find a way to do my calculations without using it.

       

      I think I had a scope problem before starting to use the RAWSQLAGG_SUM() but was totally unable to figure it out.

       

      Where do I start to understand what "Project expressions must be scalar" means?  Is this "project" referring to the relational relational algebra term?