Calculator

[Alexander]

Hello,
How can you calculate totals depending on an option field? Or in other words, I would like to sum up only visible calculation fields with each other.

salutations

[Bill Crews]

There is no entry property for visible. Hopefully, you'll know which fields to total. Just...

field("A") + field("B") + ...

[Alexander]

Thanks for the quick answer. Unfortunately, this is not possible due to the amount of data. Maybe there is a different approach to the total running time of the marked films. Greeting Alex

[Craig]

If each movie is a separate record. Put filters in tabs and use aggregate function sum on length field.

http://wiki.mementodatabase.com/index.php/Aggregation

http://wiki.mementodatabase.com/index.php/Glossary
"Filter tabs
The ability to set filters up as tabs on the Entries List screen to allow the combination of filters and quick switching between them"