# Filter calculated field **URL:** \ **Category:** Ask the Community\ **Created:** [October 30, 2019, 1:40pm UTC](https://pug.phocassoftware.com/t/filter-calculated-field/1329 "2019-10-30T13:40:07Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Robert\_Reid](https://avatars.discourse-cdn.com/v4/letter/r/aca169/32.png) [@Robert\_Reid](https://pug.phocassoftware.com/u/Robert_Reid)\ **Post date:** [October 30, 2019, 1:40pm UTC](https://pug.phocassoftware.com/t/filter-calculated-field/1329/1 "2019-10-30T13:40:07Z")
Hi, Has anyone a solution for filtering on a calculated field. Right mouse click filter returns no results, even though I can see the values on screen? Is it possible? Robert ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [October 30, 2019, 5:11pm UTC](https://pug.phocassoftware.com/t/filter-calculated-field/1329/2 "2019-10-30T17:11:14Z")
I’ve never found it overly successful - can’t remember if I ever actually managed to get it to work but I found it it much easier to get a measure adding for what I was trying to achieve as it was usually something I’d want to repeat regularly. ---
**Author:** ![Robert\_Reid](https://avatars.discourse-cdn.com/v4/letter/r/aca169/32.png) [@Robert\_Reid](https://pug.phocassoftware.com/u/Robert_Reid)\ **Post date:** [November 20, 2019, 5:01pm UTC](https://pug.phocassoftware.com/t/filter-calculated-field/1329/3 "2019-11-20T17:01:14Z")
Hi guys, Just updating on this. It appears there is a bug in Phocas that appears when you combine different date range formats in a calculation, and try to filter on a value. In my example, I was look ing at Sales (Current Month) versus average weekly over previous 42 days to get my free stock cover. By changing both to day date types, I was able to recalculate and filter as I wanted. It appears the issue lies with the ‘days’ format, and is known to Phocas. Robert