Forum Discussion
Facing problem with ABC Analysis. In the last two rows I am getting blank value for ABC Analysis
Hi Friends I am facing a problem when doing the ABC analysis. In the last two records I am not getting no value for ABC analysis. In the last two records the cost of the part is same therefore the R...
bhanu_gautam Thanks for your response. I tried the code given by you
PartRank = RANKX(ALL(PartInfo),PartInfo[Calculated_PartCost] + (PartInfo[Part_PartNum] * 1e-10),,DESC,DENSE)
This did not work as my partnum is alpha numeric so it does not accept the expresssion PartNum *1e-10. Instead of that I tried PartRank = RANKX(ALL(PartInfo),Concatenate(PartInfo[Calculated_PartCost],PartInfo[Part_PartNum]),,DESC,DENSE). In this I am getting the rank without repeating but the ranks are wrong and its not in the descending order of part cost. In the last row of ABC analysis I am also not get the value.