Pivot filter Shows all Data

[grifter]

Hi

On occasion I have to make a custom column in excel sheet and when I create a pivot and put this column in a filter the filter shows all the data instead of just the distinct values found in the field.

Value is age value and cut down the decimal places to 0, but I spoke to someone in work and they said it could be that it still considers the decimal places so it showing each unique value even though it is not displayed. Such as:

Raw Data
=======
1.223
1.56
1.72
1.557

After removing decimal places it shows:

Raw Data
=======
1
1
1
1

One of my fields was a derived field so I copied the values and pasted special the values only to see if it would make a difference to the filter - it didn't.

Any ideas how this can be fixed?

 

[grifter]

Fixed this by putting round((mycalc),0) around the calculation - this takes away decimal place and leaves whole number.

 

[pr2-eugin]

You can also use Int() to get the integer part of the Number.. As Round is a nasty piece of function that might not return result as expected.. Simple test..

? Round(1.89,0)
2
? Int(1.89)
1