Can anyone help me with the plugin authored by Evan Balister that
facilitates spreadsheet-like calculations? This is a fantastic plugin. It
allows me to perform tasks that would have been difficult before the plugin
came around. However, I have encountered a problem that has defied my best
efforts, though it appears simple.
I am using the plugin to render a series of invoices. Each invoice contains
a table of information about individual accounts. One table column in each
invoice contains numbers representing dollar figures, and employing the
formula plugin I use a filter expressions to summarize these numbers into a
running total, as described in the plugin's documentation. This part of the
process works well, and the plugin functions as the documentation
describes.
But I also wish to summarize the results from the individual invoices
creating an overall total of all of the accounts, and this is where I get
stuck. I believe that I could render a summary if I could pass the totals
calculated in the individual accounts to variables or to fields, but I have
not found a way to do that.
Here is the code as I now have it:
<$formula-vars
catch="(= sum([tag{!!reference}tag[TrustA]has[time]get[charge]]) =)">
<<catch>> {{!!total}}
<$button>
<$action-setfield $tiddler=<<currentTiddler>> $field='total' $value=<<catch>>/>
Set Total </$button>
</$formula-vars>
The filter (= sum([tag{!!reference}tag[TrustA]has[time]get[charge]]) =)
successfully renders the summary that I need in the individual invoices.
However, $formula-vars widget I use here won't pass the value rendered by
the list function on to the variable. If I substitute the list referenced
above with a simple math function, such as (= 2+3*4 =), then the calculated
value passes to the variable, and the approach seems to work, but the
$forumula-vars widget does not appear to work with filters. I am either
missing a step, or I need to find another approach.
Does anyone have any ideas?
--
You received this message because you are subscribed to the Google Groups
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/8c900358-33de-496a-9a6d-18a5b933ca6d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
