Forum Discussion
Max in column
Hi:
I'm pretty sure you need to unpivot here as MAX won't take more than a couple of columns.
Please review my solution for this instance.
Im try to create a calculet column comparind the data of other 6 columns with date and i want to know the lasted date and put in the new calulate columns, as i show in the Excel example.
Im creating a cycle time report with start proyect date and i want the date of the last activity compled thats why i need a caluclated colunm with the MAX value of 6 column of the same record
This is just one of the differents ways that i already try to get this column, asign variable to the column then with some conditional function to evaluete each one versus the other
MAX only allow 2 arguments
jmelizalde
You are absolutely right. I feel so stupid 🙂
No worries while Whitewater100 is in town. He never misses.
Have a great day!