The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
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...
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".
Thank you- Yes, the error is "non-numeric amount" for all records, so it must be the static value. Complex expression worked.
Thanks again