hmm... hiccup, i don't see any explanations on ATT functions in that post.
btw these functions can accept tags if tag types correspond to types in function signature:
$CutLeft(string,count)
$CutRight(string,count)
$SentenceCase(string)
$TitleCase(string)
$Add(number1,number2)
$Sub(number1,number2)
$Mul(number1,number2)
$Div(number1,number2)
$Abs(number)
$Lg(number)
$Ln(number)
$Log(number,base)
$Mod(number1,number2)
$Random(max_number)
$Round(number,number_of_digits_after_decimal_point)
$RoundDown(number,number_of_digits_after_decimal_point)
$RoundUp(number,number_of_digits_after_decimal_point)
$Sqrt(number)
$NumberOfDays(datetime1,datetime2)
$AddDuration(duration1,duration2)
$AddDurationToDateTime(datetime,duration)
$SubDuration(duration1,duration2)
$SubDurationFromDateTime(datetime,duration)
$MulDuration(duration, number)
$SubDateTime(datetime1,datetime2)
$Name(filename)
i mean (this note is just for consistency with other function descriptions in your sheet) that these are valid usage of functions:
$CutLeft(<field1>,<field2>)
$CutRight(<field1>,<field2>)
$SentenceCase(<field>)
$TitleCase(<field>)
$Add(<field1>,<field2>)
$Sub(<field1>,<field2>)
$Mul(<field1>,<field2>)
$Div(<field1>,<field2>)
$Abs(<field>)
$Lg(<field>)
$Ln(<field>)
$Log(<field1>,<field2>)
$Mod(<field1>,<field2>)
$Random(<field>)
$Round(<field1>,<field2>)
$RoundDown(<field1>,<field2>)
$RoundUp(<field1>,<field2>)
$Sqrt(<field>)
$NumberOfDays(<field1>,<field2>)
$AddDuration(<field1>,<field2>)
$AddDurationToDateTime(<field1>,<field2>)
$SubDuration(<field1>,<field2>)
$SubDurationFromDateTime(<field1>,<field2>)
$MulDuration(<field1>, <field2>)
$SubDateTime(<field1>,<field2>)
$Name(<URL>)
here are short description of functions you asked:
$Lg(number) returns number
$Ln(number) returns number
$Log(number,base) returns number
above are just mathematical functions: decimal logarithm of any number (or field containing number) - integer or floating point one, it's actually log(number,10); natural logarithm, it's log(number,e), where 'e' is Euler number (~2.71...); and general logarithm. these functions may be useful for volume analysis, i don't remember who requested them.
$AddDuration(duration1,duration2) returns duration
$AddDurationToDateTime(datetime,duration) returns datetime
$SubDateTime(datetime1,datetime2) returns duration (difference between two dates and/or times)
$SubDuration(duration1,duration2) returns duration
$SubDurationFromDateTime(datetime,duration) returns datetime
above functions are self-explanatory, considering that datatime may be either defined as literal (eg. 07/25/2022 or 07/25/2022 8:31 pm or 8:31:15 pm) or as any date tag in mb (eg. 'year', 'original year', 'date added', etc.). duration can be either defined as literal (eg. 00/00/0001 means 1 year, 5:00 means 5 mins, 00/01/0000 10:05:15 means 1 day 10 hours 5 mins 15 secs, etc.) or it can be obtained by subtracting two dates or two times (or two datetimes in general). also, <Time> tag (track duration) is a valid duration.
