/ doc / DocFrag / ARCQuery.FunctionKeyTMB / Description

Description

Edit keys at this level only

= TMB = Thousands, Millions, Billions.0x000D0x000A0x000D0x000AFormats big numbers in an easier to understand format as number of Thousands, number of Millions, number of Billions.0x000D0x000A(Note that K (Kilo) is used for Thousands, like 10K = 10 Thousand).0x000D0x000A0x000D0x000AUseful in economic reports where the magnitude of the numbers are more important than the exact numbers0x000D0x000A(Note: Sorting on the generated values is difficult as of Jul 2020, because it is done alphabetically).0x000D0x000A0x000D0x000ATODO: Introduce also KMGT for Kilo, Mega, Giga, Tera etc (powers of 1000), and KiMiGiTi for (powers of 1024).0x000D0x000A0x000D0x000ATODO: This function does not work well before 'ORDER BY' (-QueryExpressionOrderBy-), TODO: and we can not use it AFTER 'ORDER BY', because TODO: ordering is not kept between each -QueryExpression- (because keys are not required to be sorted in -IP-).TODO: Possible fix: Do not return PValue0x003Cstring0x003E but PValue0x003CTypeX0x003E where TypeX is understood p0x00E5 'ORDER BY' through TOOD: some standard .Net mechanism for comparing.0x000D0x000ATODO: The TypeX instance could then store both the double-value (for comparing) and its TMB-string representation (for displaying).0x000D0x000A0x000D0x000ASee -SyntaxHelp-.

Edit keys at all sub levels.
NOTE: Edits are always additive. Use 'Invalid' in order to delete keys.

Generated 2025-12-18 09:24:15.143 UTC