Jump to content

Find on a GetSummary Calc


DanBrill
 Share

This topic is 6591 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Is it possible to perform a find on a calc field that uses the GetSummary function? I'm not getting it to work, and I'm wondering if that's because the sort order isn't retained in find mode. (Is the sort order retained in find mode?) Or have I just screwed up something else?

The found set is sorted properly when I arrive at the layout, and cDonorTotals is displaying the correct information. Then:

Enter Find Mode []

Insert Calculated Result [select, 'cDonorTotals', ' ">="&gMinDonationThreshold '] {where gMinDonationThreshold is a number}

Perform Find [Constrain Found Set] {restore find request is unchecked}

It always returns an empty set. I've tried it with a NumToText function on the gMinDonationThreshold as well, but no luck.

Any help is much appreciated.

Thanks,

Dan

Link to comment
Share on other sites

Once you enter Find Mode, you lose your sort (also your previous found set), so any GetSummary calc field will always be empty at that time. I have a similar situation. My workaround is to build into the script a find and sort that will populate the GetSummary fields, then a replace-with-calc to dump the GetSummary fields into a regular (non-calculation) number field. Further operations on this value would then operate on the new number field.

Steve Brown

Link to comment
Share on other sites

This topic is 6591 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.