Functions - Where used matrix

Edit online

Applies to: TBM Studio 12.0 and later

The matrix presented below indicates where a function can be used: data sets, calculated metrics, and reports with metric columns, formula columns in report tables, dynamic text, and allocation source formulas.

Function Where Used
Data sets Calc. metrics Formula columns Dynamic text Allocation
Abs X X X X
Annual X X X
Annualize X X X
Average X X X X X
CapFirstLetter X X X X
CopyTable - - - - -
Currency X X X X
CurrentDate X X X X
DateFormat X X X X
DateSum X
Days X X X X
DomainName X X X X
DurationOfMonth X X X X
Elapsed X X X
Eval X X
EvalWiki X X
Find X X X X
GetGroupbyColumn X X
GetInfo X X X
GetLastFilterColumn X X
GetLastFilterValue X X
GetReportName X
GetReportPath X
Hours X X X X
Icon X X X X
If X X X X
IPLookup X X
IsNumeric X X X X
Key X
Large X X X
Left X X X X
Len X X X X
Lookup X X X X
Lookup_Wild X X X X
LookupEx X
LookupFromPath X
LookupMetric X X
LookupObjectTotalAllocated X X X
LookupObjectTotalValue X X X X
LookupObjectUnitAllocated X X X
LookupObjectUnitValue X X X
Lower X X X X
Max X X X X
Mid X X X X
Min X X X X
Minutes X X X X
Mod X X X X
Months X X X X
Now X X
NumberFormat X X X X
ObjectName X X
Percentile X X X
Period X X X
PeriodsInHalf X X X
PeriodsInQuarter X X X
PeriodsInYear X X X
Pluralize X X X X
Power X X X X
PreviousMonth X X X
PreviousYear X X X
ProjectExists X X X X
ProjectName X X X X
Quarter X X X
QuarterToDate X X X
Rand X X X X
Ratio X
Replace X
Right X X X X
Round X X X X
Row X X X
RowCount X X X
Search X X X X
SLN X X X X
Small X X X
SmallAcrossTime X X X
Sparkline X X
Split X X X X
StatusIcon X X X X
Substitute X X X X
Sum X X X X
SumIf X X
SumIfHierarchy X
TableMatch X
TimePeriod X X X
Trim X X X X
Trunc X X X X
Undrill X X
UniqueCount X X
UniqueValues X X X
Untag X X
Upper X X X X
Use_Map_Grid X
Value X X
YearToDate X X X