Multi-Row Formula (inserting an incorrect break in data)

I'm looking for troubleshooting ideas as to why I'm seeing some of my multi-row formulas for MAX COUNT return two values per supplier/vendor as opposed to only one value. Workflow is attached and in the results window you can see that the vendor "3 FLOW INC" is returning two values for MAX COUNT (1 and 9), when it should only be returning one value (9).

202408 Vendor NIGP Activity.yxmd

Output.png

Workflow

Accepted answers

TUSHAR050392

Hey @Chad_Cox

I think you can try other alternative. Use summarize tool, group by vendor and find the max count using max function and join it back to the data on vendor and drop right_vendor column This way will be the easiest. Let me know if you have any doubts.

All comments

OTrieger

@Chad_Cox
It is because that you are grouping it on NIGP Family and as you can see the NIPG Family is different therefore it gives you MAX for each unique family

TUSHAR050392

Hey @Chad_Cox In the multi-row formula you need to tick group by Vendor or Supplier or both. it will then give you one value against unique vendor/supplier

Chad_Cox

Looks like This may be more of me not understanding how multi-row formulas work. It appears that I am getting the correct answer in the row where the largest number occurs and then that values repeats going down until the Vendor changes. I was expecting the MAX Count value to populate uniformly on each row for each unique vendor.

My goal is to have a final report that outputs one row per vendor that shows the most used NIGP Family value and the uses the MAX COUNT and Running Total to calculate a percent on how often the Max NIGP Family occurred.

output2.png

Chad_Cox

Ticking group by Vendor, Supplier, or both has no change on the output. However, this helped me to understand the results better.

output2.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703