Skip to main content
O
OSAdmin
June 29, 2021
Solved

Sign Flip for Account in Transformation Rule (Complex Expression)

  • June 29, 2021
  • 1 reply
  • 0 views
Originally posted by Krishna Srinivasan

Hi - I have a requiremnt to flip a sign for a particular account in the transformation rule complex expression ? is there way to do it ?

 

Thanks

Krishna

Best answer by OSAdmin

If it is a particular account and only one account make it simply a one-to-one.  No need to get crazy with complex expressions.    Use the simplest method first.   

 

Even if its in a range of accounts, such as 100-200, if you put 150 in the one-to-one it will be the dominant mapping. 

 

If it requires other information, there are multiple ways to achieve this.  Does it need information from another dimension such as source product?   You can use a composite rule.   

1 reply

O
OSAdminAuthorAnswer
August 13, 2021

If it is a particular account and only one account make it simply a one-to-one.  No need to get crazy with complex expressions.    Use the simplest method first.   

 

Even if its in a range of accounts, such as 100-200, if you put 150 in the one-to-one it will be the dominant mapping. 

 

If it requires other information, there are multiple ways to achieve this.  Does it need information from another dimension such as source product?   You can use a composite rule.   

J
Julien
September 12, 2025

This solution kind of works, but can be very painful in certain situations... If you just want to flip the sign when the target account is of type revenue or liability, being able to use a complex expression or conditional rule would be way easier than defining ranges and cherry picking exceptions!

R
RobbSalzmann
September 15, 2025

Or you can modify the query in the source system to flip the sign.  With integrations, this has generally been my approach.

Terms & ConditionsAccessibility statement