I have a document library with a calculated column. This document library is populated from a windows service. Every time a new document is added, the calculated column has a formula to choose whether it is AM or PM. My problem is when I want to filter the calculated column, it has multiple values of AM and PM.
When I change the returned data type of the calculated column, the filter problem gets fixed (meaning one AM and one PM) but when a new document gets added, the problem comes back.
Has anybody encountered the same? Any ideas or suggestions are appreciated. Thanks.