Hope you're doing good. Am looking for a Idea script which can be used to knock off positive and negative values from a data set taking into considerations the GL codes as well.
Currently, I am able to perform this in an excel file by using the below mentioned formula,
Just Replace the “A” in the formula with the column for “GL code” and “B” in the formula with the column for “Net amount”
But, the above mentioned formula works only for data which is small (3000-5000 line items in excel)
I am looking to replicate the above mentioned formula in Idea, so we can replicate the same for huge amount of data as well. This would be quite useful to eliminate provision entries passed by the management.
Looking forward to your comments on this.
PS: Have attached a illustration in excel for your reference
Last seen: 1 week 3 days ago
Joined: 08/04/2019 - 05:40