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

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

I am trying to write a derivative rule with some logic in a complex expression.

Originally posted by Jon Golembiewski

11/14/2019

I am trying to write a derivative rule with some logic in a complex expression. It seems the api.parser.DelimitedParsedValues function does not work within Derivative rules? I always get back 'Index Out of Range' error. Any idea how to get it working or what function I might be able to use to replace it? I am ultimately trying to pull in the amount for a particular column in my file.

Data Sources

1 Reply

  • OSAdmin's avatar
    OSAdmin
    Icon for OneStream Employee rankOneStream Employee
    6 years ago
    Originally posted by Martin Toma

    you can't use DelimitedParsedValues in a Transformation Rule. You might have to stuff column 2 in an attribute field and use that in your rule expression. Also, you might run into issues with that setstringvalue function if you have more than 1 row with the same flight value.