Force Sort Order with Dynamic Fields

Question

I am looking for a solution on how to force sort a dynamic list of activities and have the Grand Total row always at the bottom.  I've searched through some of the other Community questions and responses on similar force sort topics and most seem to have a solution of creating an index column and then using the sort tool as a way to sort based on the indexed column.  I do not think I will be able to use this approach because the rows in the column I want sorted will be dynamic and change based on the customer the workflow is run for.  For example, customer a could have a list of 5 activities and customer b could have a list of 10 activities.  In both cases, I want the Grand Total row to always be at the last row in the output.  I'm thinking that a multi-row formula tool might be needed, although I am not very familiar with how to be use this tool.  If anyone has an idea on how I can accomplish this, I would appreciate some ideas.

Thank you!

Force Sort.xlsx

Ben_H · Answer

Hi @Brost,

Does it matter what orders the activities go in?

If not why can't you just do what you suggested above?

The example below just checks if the Activity column contains "Grand Total", if yes 1, if no 0 and sort on that.

Regards,

Ben

IraWatt · Answer

Hey @Brost,

This workflow ensures that a grand total is always appended

Grand Total.yxmd

binu_acs · Answer

@Brost one way of doing this use a filter tool and filter out based on activity = “Grand Total”

then union the results from the both output of filter tool . Check the sort order option in the union tool make sure the the True record from the filter tool always be the last one

grand_total_12_05.yxmd