Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Can you brief your requirement, what are you looking for in the table
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