You might also try this plugin for a more excel like expeiance.
https://chronicles.wiki/TiddlyWikiFormula/
On Tuesday, 23 February 2021 at 16:39:29 UTC Eric Shulman wrote:
> On Tuesday, February 23, 2021 at 8:21:46 AM UTC-8 brad.d...@gmail.com
> wrote:
>
>> ...how to do calculations and formulas in TW. At the moment I would like
>> to do the following:
>> =INT(({{!!myfield}}-10)/2)
>>
>
> Calculations are done using the "filter" syntax. There are several ways
> to do this.
>
> * direct rendering using "filtered transclusion"
> {{{ [{!!myfield}subtract[10]divide[2]trunc[]] }}}
>
> * using the $set widget with "filter" parameter
> <$set name="result" filter="[{!!myfield}subtract[10]divide[2]trunc[]]">
>
> * using the $vars widget with filtered transclusion as a parameter
> <$vars result={{{ [{!!myfield}subtract[10]divide[2]trunc[]] }}}>
>
> Notes:
> * within the filter syntax, field references use *single* curly braces.
> * there isn't any filter syntax for using parentheses in calculations, so
> the order of operations is very important
> * sometimes this means using several filters to calculate intermediate
> results and then combining them.
>
> For example, to calculate something like this:
> INT(({!!myfield} / 2) - ({!!myfield} - 5))
>
> You could write:
> <$vars part1={{{ [{!!myfield}divide[2]] }}} part2={{{
> [{!!myfield}subtract[5]] }}}>
> <$vars result={{{ [<part1>subtract<part2>trunc[]] }}}
>
> enjoy,
> -e
>
--
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 tiddlywiki+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/0446db7f-7087-4550-841d-fbec938f937fn%40googlegroups.com.
