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

Steven's avatar
Steven
Contributor II
2 years ago
Solved

Derivative Transformation Rule ActualQuantity field as Amount

I would like to create a derivative transformation rule that will add _Qty to the end of the Account and pull the ActualQuantity field from the data source as the Amount. My DataSource has a field f...
Parsing
  • JackLacava's avatar
    JackLacava
    2 years ago

    It's difficult to judge without looking at your full datasource configuration, but there are many ways to skin this particular cat. You could map the column to an Attribute Value dimension (e.g. AttributeValue1), then use args.GetNumericValue("AV1#") . You could get it by column index from api.Parser.DelimitedParsedValues(yourColIndex). Keep in mind that most values will be treated as text, not Numeric, even if they are numbers; so you will want to get them as "Dimension Values", unless they are in Amount or in Attribute Values.

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

Is the DataSource a Matrix type, by any chance?

Steven's avatar
Steven
Contributor II
2 years ago

No

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    It's difficult to judge without looking at your full datasource configuration, but there are many ways to skin this particular cat. You could map the column to an Attribute Value dimension (e.g. AttributeValue1), then use args.GetNumericValue("AV1#") . You could get it by column index from api.Parser.DelimitedParsedValues(yourColIndex). Keep in mind that most values will be treated as text, not Numeric, even if they are numbers; so you will want to get them as "Dimension Values", unless they are in Amount or in Attribute Values.

    • Steven's avatar
      Steven
      Contributor II
      2 years ago

      api.Parser.DelimitedParsedValues(3) returned:  "Unable to execute formula. Index was out of range. Must be non-negative and less than the size of the collection.  Parameter name: index"

      I tried to use the Attribute dimension with this business rule: 

      "Return Integer.Parse(args.GetNumericValue("A1#"))"

       

      This just returned 0

       

      When I tried the Attribute Value dimension:

      "Return Integer.Parse(args.GetNumericValue("AV1#"))"

      this worked.

      Thank you!!!