How to Subtract TWO paglist values ?
Hi ,
As per requirement, i have Two pagelists 1 is invoicelist().AT and another one Create.activitylist().T
I want subtract invoicelist().AT - Activitylist().T
How to loop it ? and how to reslove it please let me know
Thanks
Cognitonic Systems Australia
AU
@keerthiy You can use data transform to achieve this requirement.
There are two scenarios to consider:
Sc1: If you want to subtract the data from same indexes of both the page lists then you can achieve in the way in screen shot1.
Eg: invoicelist(1).AT - Activitylist(1).T, invoicelist(2).AT - Activitylist(2).T
Sc2: If there is any common attribute that contains unique value between the two page lists and if you want to subtract the data only from that specific attribute value object then it can be achieved by fetching the index of the attribute value from second list and use that index as subscript by looping.
Eg: InvoiceID is attribute which is present in both pagelists with some value which will be unique in list1 and also list2 but the value of invoiceid that is in invoicelist will have one page object in Activitylist then the below approach.
1. Loop on InvoiceList
2. Get the index from Activitylist based on the unique attribute value of current iteration InvoiceID. You can use indexinpagelist function.
3. Subtract by specifying that index as subscript for Activitylist.
