Calculations using Saved Searches

[Yvette M]

Can I get a “total calculation summary” on a result list from a saved search?

[Brendan]

Hi Yvette,

Yes you can.

Just set the Summary Calculation field property on your Number, Calculation, Rating, or Checkmark fields and you’ll see the result displayed at the bottom of the records list view. When you have a Saved Search selected, the summary calculation will pertain just to the found records.

Thanks!

Brendan

[Yvette M]

Thanks!

[Yvette M]

It’s not working for me.

I imported my credit card statement. It’s very simple.
These are fields:
Name And Type
1. Date – Date
2. Card # – text
3. Description – Note
4. Debit – Number
5. Credit – Number

My form has a calculation set to the field debit

Both Debit and Credit has summary calculations set to total.

I saved a search where the field credit is set as not empty so the resulting list is that of all my credits.

I’d like to see a total of just those records. Instead the search result list still shows debit at the bottom with a total of $0.00

What aren’t I doing?

I know it should be simple!

Thanks
Yvette

[Brendan]

Hi Yvette,

Can you please email me your form template and I’ll have a look at it for you?

Thanks,

Brendan

[Author]

Posts