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!