cancel
Showing results for 
Search instead for 
Did you mean: 

How to acive below rule?

former_member350687
Participant
0 Kudos

How to acive below rule?

If Invoice Amount is greater than 0, multiply Amount Allocated # 1 (Serengeti File) by -1.

If Invoice Amount is less than 0, multiply  Amount Allocated # 1  (Serengeti File) by 1.

Replace ',' with blank.

Example:

1,495.32 *-1=1 495.32-

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Are using BRM for applying the above rule or do you want to implement the rule at mapping step

if BRM if else condition can be applied ...what issue you are facing here. ?

if at mapping using if (inv amt >0) then multiply else if (inv amt < 0 then multiply) and for the output of if else condition use replace ....

your query is not so clear ..please be specific for more replies..

HTH

Rajesh

former_member350687
Participant
0 Kudos


Hi Rajesh,

If Invoice Amount is greater than 0, multiply Amount by -1.

If Invoice Amount is less than 0, multiply  Amount by 1.

Replace ',' with blank.

Example: if Amount is 3 ie graterthan 0 so we have to multiply it with -1

1,495.32 *-1=1 495.32-

I want to do this in Mapping not the BRM.

So can you tell me how to do this if condition.

Regards,

Mahi.

Former Member
0 Kudos

Hello,

Check this:

Thanks

Amit Srivastava

Former Member
0 Kudos

Hi Mahi,

As per my understanding your requirement is like below.

If I/P =1,49532 ,then o/p should be -149532

If I/P =-1,49532 then o/p should be -149532 (pass it as is )

Implement the below mapping logic

Regards

Venkat

former_member350687
Participant
0 Kudos


Hi All,

Thanks for your reply.

Regards,

Mahi

Former Member
0 Kudos

If ur question has been answered then u have to close ur thread.

Read "SCN Rules of Engagement"

Answers (0)