Sign Flip for Account in Transformation Rule (Complex Expression)

[OSAdmin]

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

[OSAdmin · Accepted solution]

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.