Calculate With Text Values

Master Tag
Tips & Tricks
Created
Aug 17, 2020 07:41 PM
Usage
toNumber
Subtract
Slice
Web Tags
Database
Formula
Relation
Alternatives
Cover
Timeline Example
Calculate With Text Relations
Name
Year Started
Year Dissolved
Years Active
Orgs. Dissolved Before 2000
Years Active: toNumber(prop("Year Dissolved")) - toNumber(prop("Year Started"))
Orgs. Dissolved Before 2000: toNumber(prop("Year Dissolved")) < 2000
Calculate With Page Name
Years Active: toNumber(slice(prop("Name"), -4)) - toNumber(slice(prop("Name"), -11))
Orgs. Dissolved Before 2000: toNumber(slice(prop("Name"), -4)) < 2000