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

vijay's avatar
vijay
New Contributor III
2 years ago

Transformation rules Subtract two accounts

hi,

Two account A and B needs to be subtracted in the source applicaiton and assigned to the third account on destination application  in the transformation rule for App2App copy process . Below is my Composite but its throwing error for one-one transformaton mapping.  

TR Composite Rule:

Validaiton error:

 

 

Finance

3 Replies

  • AndreaF's avatar
    AndreaF
    Contributor III
    2 years ago

    The Rule expression field of a Composite map rule is meant to define the conditional mapping, eg. A#[199?-???*]:E[Texas], it is where you specify the source field. You need to use the logical operator field to extend the normal mapping rules with VB script functionality. However, in your case I would probably use derivative rules.

    • vijay's avatar
      vijay
      New Contributor III
      2 years ago

      Thanks , Any sample or link for the above.

  • AndreaF's avatar
    AndreaF
    Contributor III
    2 years ago

    I had a second thought about it, and the easiest way is actually just using 2 one-to-one mapping rules, with signed flipped on the second to indicate the value must be subtracted instead of added. Like this:

    Please mark the post as answered if this solves your issue. Thank you