I have a dataset and need to do a pivot table with an average.
I need to truncate the average as follows:
Say the average is 95.6
I need to truncate it to 95
The same if it is 83.23
I need to truncate it to 83
So I don’t want to round it up or down but to truncate it.
Any assistance is appreciated.
Thank you.
Bookmarks