2 Replies Latest reply on Jul 18, 2012 1:53 AM by Ivett Kovács

    number and string

    Ivett Kovács

      How can I create this calculated field?

      [Goals Tracking] = String

       

      ([today_status])= float

       

      IF[Goals Tracking]=" Goal 1: leads to active" THEN STR(sum([today_status]) + " leads today" end

       

      The calculation error is:cannot mix aggregate and non aggregate arguments.

       

      Please, help!