multi row formula

[Sarath27]

Hi All,

Group the Levelling Key - then whichever the line has greater "Total" value then that respective Product of that line should be populated in both the lines.

Levelling Key	Product	Count	Sum_Level 1	Sum_Level 2	Sum_Level 3	Total	Group_ID	Right_Group_ID
BSP627819839-7758Debt Securities (Trading)0012530002	Bond - Corporate	4	0	33.61	0	33.61	399	399
BSP627819839-7758Debt Securities (Trading)0012530002	Government bond - US - coupon bearing	11	0	8707994	0	8707994	399	399

[aatalai]

@Sarath27 something like the workflow I've attached?

[Sarath27]

Nope. I want the Product to be populated whichever the line has highest total.

[aatalai]

@Sarath27 so something like this

[acotta17 · Accepted solution]

Hi @Sarath27,

In addition to using the Multi-Row Formula tool, you could also follow the method outlined in the attached workflow.