Summing values in fields

[Jon]

Hi,

is it possible to sum the values held in Field A wherever the field exists, or do the individual tiddlers where it does appear, need to be referenced?

Regards

Jon

[Eric Shulman]

On Thursday, February 13, 2020 at 12:35:26 AM UTC-8, Jon wrote:

is it possible to sum the values held in Field A wherever the field exists, or do the individual tiddlers where it does appear, need to be referenced?

Using filters, you can write:

<$list filter="[get[A]sum[]]" />

The get[A] operator retrieves a list of all values from all tiddlers that have a field named "A".

Then, the sum[] operator adds up all the retrieved values.

-e

[Mohammad]

Jon

 Take a look at Shiraz Plugin 2.0.16

 https://kookma.github.io/TW-Shiraz/#demo%2Fdynamic-tables-numerical-summary:demo%2Fdynamic-tables-numerical-summary%20demo%2Fdynamic-tables%2Fcustom-numerical-summary

It has some great features for performing simple calculation on filed values!

--Mohammad

[Mohammad]

a small side note: TW fields are in lower case! 

-e

[Jon]

Thanks Eric, I really am going to have to start learning this stuff!

And thanks Mohammad, I can see your plugin is going to be invaluable.

Regards

Jon