1 Reply Latest reply on Jul 10, 2018 1:07 PM by Deepak Rai

    Creating a Calculated field using Strings and Floats

    MICHELLE PAREKH

      I am trying to create a calculated field using the following:

       

      [Expense Report HeaderID]+"."+[Card Transaction Billed Amount]+"."+[Card Merchant Name]

       

      Expens Report HeaderID is a numeric value

      Card Transaction amount is a numeric value

      Merchant name is a non-numeric value

       

      The error I receive, is that you cannot combine floats and strings.

       

      Don't know how to create this?