Hi Team,
Hope you are well. I need help.
I need to sum the values of a column based on the id. Final output column is marked in yellow.
Thanks ,
Sri
@sriniprad08
This is your sample as a sub_num I thought there was something wrong with the calculations. If so, could you explain the formula?
I put a view of mine below in the print.
to have a result I did the sub_num my way
it will always be on 2 lines.it would be ideal for you to send an example with more sample data
@geraldo : Thank you . Just attached the sample data.
Hi @sriniprad08 - we need more information. Because based on what you provided, I can only assume that it will always be for the Max line of the 2nd column, and the sum of values of the first column - all provided by the Group of ID. Since this is just an assumption, the workflow I have here may not account for all your needs - please be mindful of this.
Hi @caltang ,
Thank you for the solution. Appreciate it. I have attached the updated data.
Please let me know if this looks ok.
Thank you.I tried with the but its giving different results.
sorry may be i am missing something. Do i need to add record id at the end of the flow?
Cheers,
Other example
Hi @geraldo ,
Perfect. Thank you. Great one challenge sorry which i forgot to mention.
There is another column called sub_num. So the flow as to take into consideration num and sub_num.
Please find attached and let me know how to go about it,
@sriniprad08 - @geraldo ‘s solution is more elegant. Go with his, it will solve your need.
Thank you @caltang Appreciate all your help
