Could you check if "Aggregate Measures" under Analysis tab on your Desktop is checked?
Yes- it is.
But if I turn it off - the values get all wacky as well. Let me know if there is something else I need to do.
Can you attach packaged workbook with some sample data?
I actually was able to get it working I think -- using this instruction:
I then filter the field against the newly calculated one.... seems to be OK now
Thanks for the offer... if I run into any more issues I will send out a packaged workbook with dummy data.