[Troy DeGroot]

First, you will need to update your waste custom column and move the decimal two spaces. Your 10% waste should be 1.10 not 110. this will work better in the calculation. While you’re updating that custom column, I would uncheck the box that says Show Totals, it only confuses things when it show a total of percentages added at the top of the column. The, you need to create another custom column with a formula that takes the measurement x the waste factor.

[Dakotah Cooper]

Fixed, and things are moving well. Thank you.

[Troy DeGroot]

Of course @dakotah great question.

Glad you’re here in the community, welcome!

[Dakotah Cooper]

Thank you again, by the way.

[Doug McLean]

Hopefully you are writing your formula based on your Measurement column, and not your Length column.
Just something to keep in mind.

[Dakotah Cooper]

I am trying to figure out a way to select two columns at once to sort markups. I would like to preferably be able to organize with subject and layer simultaneously. Is this even possible?

[David Cutler]

That’s a good question @dakotah . As far as I know Revu only allows you to sort by 1 column. Unfortunately it doesn’t have all of the functionality of Excel…

When I started using Revu exclusively for takeoffs 5 years ago I quickly found that exporting my data to Excel as a .CSV file made the information soooo much more usable. I highly recommend using Excel for your analysis, rather than trying to find work around in Revu.

Welcome to the Brainery BTW! Keep the questions coming. 🙂

[Troy DeGroot]

@DavidCutler is correct regarding the lack of this particular functionality in Revu and the value of exporting to Excel. I’m not sure if this would be exactly what you need, but you could try filtering by one column value and sorting by the other. The only time you can sort by two columns is if you set that up in the export settings. Love the questions, keep us posted.

[Dakotah Cooper]

The Sorting method is working seamlessly. Thank you!