Calculator

62 views
Skip to first unread message

Alexander

unread,
Jan 14, 2018, 3:39:50 PM1/14/18
to mementodatabase
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

unread,
Jan 14, 2018, 5:47:19 PM1/14/18
to Alexander, mementodatabase
There is no entry property for visible. Hopefully, you'll know which fields to total. Just...

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

Alexander

unread,
Jan 17, 2018, 4:32:47 PM1/17/18
to mementodatabase
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
20180117_222006.jpg

Craig

unread,
Jan 17, 2018, 8:03:36 PM1/17/18
to mementodatabase
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"

Reply all
Reply to author
Forward
0 new messages