Omission of loop created & to achieve what is expected
Dear Our Experts
Please help me to overcome the issue I am forwarding to you. I have loaded two tables both table carries BR_CODE , PRODUCT_CODE hence when the data are loaded a loop is created. What I did was to rename the BR_CODE as B_CODE then the former issue wont come but what I expect is not getting. As can be seen what is in the NRP Table total sum of both RA & EH get populated in every Branch code. Actually what is in the NRP table carries data for only RA & EH codes. Please go through my working & help me to get my output.
What I need is to get NRP in one column calculated based on data in the TB Table & In line table & again get the NRP from cross table structure & to be matched. If I keep only one Branch data (RA or EH ) in the cross table, I get the NRP Figures separately in two columns & be matched. But once one more branch is added, results are produced with the addition of both Branches.
After all,
RA Code figures for each Product codes obtained from the formula to be placed against the same kind of figures obtained from cross table data.
