The attached file represents a list of procedures; M represents tooth range which could be 1-8 UR, 9-16 UL, 17-24 LL and 25-32 LR (called quadrants); that is identified in columns W, X, Y, Z
The problem I am having is with OralSurgery module; it's visible what it does and how it does it, it identifies one first entry, copies it in the schedule proposal and delete it from the source; then if other entries for the same identifier exist in column A, that are in the same quadrant, it adds the numbers listed in column M (in the source), it column AE (at the destination); also when it does that, it needs to exclude lines that have any entry in column R;
It kind of works only halfway and I don't see where's the mistake; it should put in column AE of the destination the following: 31, 29, 28, 27, 26, 25 (because they are all in the same quadrant as the first entry found (LR); but it should not add 31 and 32 because an entry exists in R
Willing to transfer 20 points for a solution.
Bookmarks