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

[Chad_Cox]

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).

[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.

[Chad_Cox]

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

[TUSHAR050392 · Accepted solution]

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.