Forum Discussion

Chap's avatar
Chap
New Contributor II
2 years ago

Loading Headcount from Table with no Values

Hello- I'm trying to load Headcount into our Finance model as a statistic. The table has no not data fields, just people records and emp ID. When I try to put a "static value" override of 1.00 in the...
  • JackLacava's avatar
    2 years ago

    Look at the actual load logs (those icons at the top of the Import page, one has a little gear...). Each skipped line will have a numeric code associated with a specific error. If it's "non-numeric amount" then it's indeed a problem with your static value; it might be that it's passed to the field as a string, when it has to be a number. You should be able to bypass that by using a Complex Expression instead, containing just "return 1".