Forum Discussion
Solved
Max with Text data
I need to get the Max (or latest) Version by FullBuildID, problem is the FullBuildID is not a numeric value so when I use Max it returns a 0. Here is a sample of my data: Product Version Ful...
You could create a new column like this:
FullBuildNum = SUBSTITUTE([Full Build ID],".","")
Switch the column to Whole Number.
You could create a new column like this:
FullBuildNum = SUBSTITUTE([Full Build ID],".","")
Switch the column to Whole Number.