2 Replies Latest reply: Jan 6, 2012 8:22 AM by Anne Duffy RSS

    Syntax error on load for if statement with sum

      Hi Guys

      if(sum(today()-[Date the Error was discovered])= '20',upper([Customer Name])) as

      [CPC 20 Error Name]

       

       

      As a work around for an Alert - I need to create a field made up of specific customer names.

      I am trying to take the date an error was discovered and count how many days it is open ( By minusing it from todays date !!) if this is equal to 20 then creating a field called

      [CPC 20 Error Name] that contains the names that was in Customer name,

      I keep getting a syntax error on load , I think its how I have written the sum formula -- Can anyone please help ?

      Thanks

      A