I know this was discussed before but I couldn't find a solution to my problem.

I am trying to filter a table to show non zero balances where Balance is an unstored calc field.

I know that searching an unstored calc field isn't a good thing but I don't know how else I can get the info I need.

Please see attached

Any help will be highly appreciated.

To rectify: There is a mistake in the attachement: the seach is on Balance field (the calc field) and not on the TotBal field (the summary field).

Thus The problem is: the seach is slow when I search the Balance field in Transactions.

sorry the mistake.

slowsearch.pdf

Edited September 13, 200817 yr by Guest

well you could use a custom function CustomList Function http://www.briandunning.com/cf/868

And using a relationship to your transactions just create a custom list based on the values

such as

parentkey ---

BalanceKey = CustomList ( 1 ; Count(transactions::parentkey) ;

"Case( GetNthRecord ( transactions::balance ; [n] ) ≠ 0 ; GetNthRecord ( transactions::parentkey ; [n] ); "null" )" )

this will result in a return separated list that is all related records with a balance.

Then you can use this as a key for another relationship to create a portal of anything w/ balances

BalanceKey ---

you can do a goto related based on this and get a list.

Create another field to store the results of the calculated unstored field. Set the stored field equal to the unstored field just prior to the find. Then find on the stored field.

Hello m3nme:

I created a new field (number) and ran the ReplaceFieldContent (new field = calc field) to populate it. It took FM a long time to populate the new field, the find was very fast. So the time gained in fast search is lost in slow RFC.