Can't perform a find on summary calculation field

[liltbrockie]

Hi, I have a very simple calculated field which just does Sum(someOtherRelatedTable) and the field shows the correct number

But I can't do a find eg: >0 on that field... it just says no records match.

Any reason for this?

[comment]

Can you post an example file showing this?

[liltbrockie]

Yeah hang on ill have to strip it down a bit first...

[liltbrockie]

Bizarre... I grabbed a copy of the file from the server and tried the same search and it works!

Server hosted file search doesnt work .. local copy search does work..? Something to do with cache?

[liltbrockie]

Just double checked this...

Search works on a local copy but not on a server hosted copy.

??

Gonna try and lower the cache on the server.. cant think what else to do.

[liltbrockie]

Just double checked this...

Gonna try and lower the cache on the server..

Did not work

[liltbrockie]

Problem solved.

Edited August 18, 2010 by Guest

[phcranston]

I'm having the same problem here. Can you detail how you resolved the problem? Thanks

[liltbrockie]

I reinstalled FM Server and it started working as expected... bizarre.

[phcranston]

Thanks for the response. I was able to resolve my problem by just rebooting the server. Also bizarre, but fortunately an easier fix for me.