Logic Help

[abhaysingh]

Hi All,

i need some help in logic,

data is

Field1	Field2	Amount	output
SMELAP	assign	100	120	assign90= means 90 % of amount
SMELAP-ASSIGN	assign90	200	180
SMEWC-ASSIGN	assign	300	300

order of field 1 can be different, please suggest

[rahulpawarb]

Hello Abhay,

Trust that you are doing well!

As per my understanding you want to produce an output field based Field2 values. When Field2 is assign then produce 100% of amount; when it is assign90 then produce output as 90% of amount. Please correct me if I am wrong.

Regards!

Rahul

[kkkumar82]

Can you brief your requirement, what are you looking for in the table

[abhaysingh]

Hi Rahul,

Thanks

Yes you are correct, adding one point, when assigned90 then rest 10% should be club in SMELAP, in data first row, u can see 100 become 120 in output.

Regards

Abhay