Thanks to both of you! I'll give these a try. On Tuesday, February 23, 2021 at 12:22:29 PM UTC-6 Ste wrote:
> 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 [email protected] >> 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/0f8441f7-dd6e-4821-8214-c8b9e0abf9cbn%40googlegroups.com.
