Welcome Brad! AFAICT, the INT function is the same as TiddlyWikis floor operator <https://tiddlywiki.com/prerelease/#floor%20Operator%20(Examples)>. (But floor also works on multiple numbers at once).
TW has quite a few math filter operators <https://tiddlywiki.com/prerelease/#Filter%20Operators> if you didn't see them already. <:-) On Tuesday, February 23, 2021 at 9:01:44 PM UTC+1 [email protected] wrote: > 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/e20e19f7-d216-4d9d-9b1d-0217b4fb8157n%40googlegroups.com.
