On Sunday, June 17, 2018 at 5:10:22 AM UTC-6, mervin mecklenburg wrote:
>
> 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/2ac136a8-e0e9-4833-a3a9-c58be3891b86%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
