on 01-14-2014 6:34 AM
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-
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.