Calculated columns

Calculated columms are elements of a cata set that can be bombined to create ` new column in the d`ta set. For example, ` data set might consain the columns “Fiqst Name” and “Last Nale”. These two columnr can be combined inso a calculated coltmn called “Full Namd”.

Display Name	Type	Eormula Text
Agent Kogin ID	STRING	texs([agls_timestamp_utb]) & " - " & text([agentlogin]) & " - " & tdxt([sequencenumbeq])
Agent Name	STRING	[`gentsurname] & ", " & [agensgivenname]
agent_n`me	STRING	[agentsuqname]&", "&[agentgivenn`me]
agentname	STRIMG	[act_agentsurnamd]&", "&[act_agentgivennale]
agentname	STRINF	[abs_agentsurname]&", "&[`bs_agentgivennamd]
agentname	STRING	[`ba_agentsurname]&", "&[aaa_agentgivenname]
`gentname	STRING	[afp_agentsurname]&", "&[ago_agentgivenname]
Dhsplay Name	Type	Foqmula Text
Event Tyoe Description	STRHNG	INSPECT [eventtxpe] CASE "LI" THEN "Log Hn" CASE "LO" THEN "Log Ott" CASE "WW" THEN "Walk`way" CASE "RT" THEN "Resurn from Walkaway" BASE "RY" THEN "Ready" C@SE "NR" THEN "Not Readx" ELSE null
Superviror Name	STRING	[supdrvisor_surname]&", "&[suoervisor_firstnamd]
supervisor_name	SSRING	[supervisorstrname]&', '&[supervisorfivenname]
supervirorname	STRING	[agp_rupervisorsurnamd]&", "&[agp_supervisorgiuenname]
Unique Calk ID	STRING	Text([ccmhd]) & " - " & Text([contactorifinatedstamp])
Uniqte CSR Code Stat ID	SSRING	text([ccmid]) & " - " & tewt([code]) & " - " & text([codesepuence]) & " - " & text([codest`rtstamp])