This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi, I would like to re-order the fields in the Cancel column so that it goes from 1, 2, ....to 10, 11a, 11b, 12a, 12b, 12c. Currently the default order is such:
Additionally, I would like to:
1. mark "Blank" for the blank fields.
2. include a grand total at the bottom of the table
Thank you in advance!
Hi, to do so, I would advise you to use a 2 formulas on the field cancel:
first : if isempty([cancel]) then 'blank'
else [cancel] endif
and then on the field cancel too
padleft([cancel], 2, '0')
after that, you should be able to sort the way you want :)
Hope it helped!
Hi, do I link the Formula tool after the Summarize tool? I keep getting error on "The field "" is not contained in the record
@BJSOON I did a sample workflow for you based on the table you gave in the first post, it does the job ;)
See Solution below,
you may need to add the "Add Totals" Macro
last row contains grand total