Columns Computed Column

Computed Column

Computed column doesn't have predefined way to know what value to display in it cells. It is our job to define it. Computed column has ColumnType.COMPUTED type. It doesn't have field property. Insted, we have to specify formatter property containing logic about what to display in the cell.

{
  //specify the type is COMPUTED
  type: ColumnType.COMPUTED, 

  //Specify what to display in the cell
  formatter: (val: any, rowData?: any) => rowData['gender'] + ' - ' + rowData['country'],
  
}

The gray and red columns below are computed.

Name
Gender
Gender - Country
Amount
Computed (Amount / 2)
Country
Abagail Kingscote F F - PH 9339.72 4669.86 PH
Nicolina Coit M M - KZ 3744.95 1872.475 KZ
Sarene Greim M M - US 4397.68 2198.84 US
Blair Millbank F F - PH 3334.58 1667.29 PH
Kliment Sprowle M M - ID 6459.93 3229.965 ID
Winifred Dikle F F - KZ 9833.93 4916.965 KZ
Chadd Nacci M M - CN 4383.54 2191.77 CN
Matthiew Morland F F - GR 9727.9 4863.95 GR
Perceval Glasheen M M - NL 7201.29 3600.645 NL
Fenelia Oblein M M - SE 3654.03 1827.015 SE
Lisette Ornells F F - CU 6775.49 3387.745 CU
Mellie Anthill M M - PH 7474.3 3737.15 PH
Charles Simkovitz M M - BR 7871.4 3935.7 BR
Brett Hew F F - MK 6925.89 3462.945 MK
Netti Treend F F - PE 6569.53 3284.765 PE
Donetta Scotland F F - RU 7647.54 3823.77 RU
Larry Candish F F - MN 8287.03 4143.515 MN
Ianthe Nijssen M M - GE 3230.41 1615.205 GE
Rivalee Heavyside M M - ID 5557.91 2778.955 ID
Ekaterina Heyburn F F - ID 5916.96 2958.48 ID
Cynthia Garrard F F - JM 3155.08 1577.54 JM
Bruis Henryson M M - RU 4079.36 2039.68 RU
Brittani Swaby F F - UA 7766.85 3883.425 UA
Johnna von Hagt M M - UA 7231.27 3615.635 UA
Brooks Kalberer F F - SE 3130.28 1565.14 SE
Osmond Beevens F F - CN 5242.18 2621.09 CN
Stephi Forsdicke M M - CN 3027.02 1513.51 CN
Kristan Collingworth M M - CN 6649.44 3324.72 CN
Bord Petkov M M - SE 6362.19 3181.095 SE
Nara Boorne F F - AR 6527.11 3263.555 AR
Ransell Bullingham M M - PH 8855.43 4427.715 PH
Kerr Eastcott F F - CN 5105.78 2552.89 CN
Victor Hallgalley M M - CN 3361.66 1680.83 CN
Delia Rosendale F F - FR 4381.41 2190.705 FR
Mickey Belding F F - CN 8716.32 4358.16 CN
Pippo MacColl F F - FR 6428.34 3214.17 FR
Radcliffe Castellet M M - CN 6133.15 3066.575 CN
Arvie Maxweell F F - TH 7053.02 3526.51 TH
Darnell Valler M M - PL 4982.23 2491.115 PL
Mirilla Ziems F F - CN 6263.73 3131.865 CN
Werner Dorin F F - PH 3215.49 1607.745 PH
Dael Lesek M M - CN 4099.27 2049.635 CN
Diarmid Dmytryk M M - BR 3144.37 1572.185 BR
Eunice Reily M M - ID 3477.99 1738.995 ID
Matty Duddle M M - MK 5296.22 2648.11 MK
Luciano Godilington M M - FR 4139.65 2069.825 FR
Stacie Vassie M M - UA 8122.35 4061.175 UA
Aharon Samter F F - OM 4361.33 2180.665 OM
Hillery Canedo F F - IR 9719.7 4859.85 IR
Jacquelin Crowcombe F F - MA 7359.53 3679.765 MA
Allayne Bachelor M M - PL 3332.5 1666.25 PL
Lindie Bodley M M - AM 3413.69 1706.845 AM
Sharia Roskelly F F - BG 8705.67 4352.835 BG
Saul Ubsdale M M - FR 7604.27 3802.135 FR
Nate Churms F F - CO 7457.68 3728.84 CO
Tracey Bucknall M M - AF 9351.93 4675.965 AF
Carole Sparrow F F - RU 6366.73 3183.365 RU
Jennica Pashba F F - VN 4825.08 2412.54 VN
Carlotta Turvey F F - PH 6191.06 3095.53 PH
Drucill Roaf F F - CN 4394.57 2197.285 CN
Lucien Steuart F F - JP 5225.22 2612.61 JP
Daryl Slimon M M - PT 6995.5 3497.75 PT
Sheelah Laydon M M - PL 7313.91 3656.955 PL
Bertie Brewood M M - CI 9912.11 4956.055 CI
Louise Rosin M M - HU 8218.1 4109.05 HU
Ara Gaskins F F - BG 5960.34 2980.17 BG
Roshelle Tollemache F F - MX 5319.58 2659.79 MX
Mabelle Schwanden F F - VN 6830.94 3415.47 VN
Fayina Parsonson M M - CN 5845.86 2922.93 CN
Chancey Blackway F F - FR 6252.95 3126.475 FR
Josee Dasent M M - CN 7682.65 3841.325 CN
Larisa Dillway F F - CN 5202.31 2601.155 CN
Oby Woolard F F - RU 5111.98 2555.99 RU
Marylou Lebang M M - ES 7076.7 3538.35 ES
Nollie Rillett F F - CI 9177.99 4588.995 CI
Jillayne Geal F F - CN 8314.71 4157.355 CN
Andreas Marling F F - SN 8927.05 4463.525 SN
Edwin Kilmister F F - UA 4888.32 2444.16 UA
Hershel Cornelis M M - ID 4712.07 2356.035 ID
Nancy Tomanek F F - RU 8979.17 4489.585 RU
Kikelia Hawgood M M - AL 8688.32 4344.16 AL
Cele Thridgould M M - PL 4559.98 2279.99 PL
Petronella Fairbank M M - CZ 7322.4 3661.2 CZ
Thorn Maruszewski M M - SY 5074.47 2537.235 SY
Jodi Tall F F - KG 8097.92 4048.96 KG
Bail Ehlerding F F - CN 8739.09 4369.545 CN
Natal Thorald M M - HR 7632.75 3816.375 HR
Krishna Burwood M M - PL 4722.89 2361.445 PL
Zarah Mousdall F F - CN 8195.89 4097.945 CN
Torre Moss F F - CN 3262.7 1631.35 CN
Merry Paridge M M - CN 8407.38 4203.69 CN
Laurene Lucius F F - PH 4604.98 2302.49 PH
Isa Braine M M - PA 4844.65 2422.325 PA
Leisha Tompsett M M - CN 6575.16 3287.58 CN
Florry O'Doireidh M M - DK 4294.56 2147.28 DK
Sophi Roberti M M - CN 3185.59 1592.795 CN
Leanora Nester M M - CN 7958.93 3979.465 CN
Giacopo Stallion M M - CN 8455.91 4227.955 CN
Euell Yanshonok F F - CZ 5455.26 2727.63 CZ
Cyrillus Gilstoun F F - CN 5418.84 2709.42 CN
Syman Navarijo F F - CN 8429.9 4214.95 CN
Alix Spottiswoode F F - CN 4768.97 2384.485 CN
Papagena Yokelman F F - MA 8376.06 4188.03 MA
Major Charleston M M - PK 8223.86 4111.93 PK
Lelia Cade M M - PE 3947.65 1973.825 PE
Nixie Cescon F F - CN 7672.44 3836.22 CN
Toddy Readett F F - NG 5388.16 2694.08 NG
Sauveur Grigoire M M - NL 8208.87 4104.435 NL
Vincenz Niese M M - FR 3983.82 1991.91 FR
Minny Bulfit F F - RU 7830.92 3915.46 RU
Jolie Amys F F - ID 6595.45 3297.725 ID
Wayne Pinfold F F - PH 7475.46 3737.73 PH
Esra Cawdery F F - PL 6352.95 3176.475 PL
Norrie McElhinney M M - PL 3879.86 1939.93 PL
Allyce Audrey M M - TN 4638.67 2319.335 TN
Callida Lotte F F - ID 6540.29 3270.145 ID
Wald Awcock F F - ID 7636.69 3818.345 ID
Ketti Gannon F F - CN 8917.53 4458.765 CN
Tris Coleshill F F - ID 4118.17 2059.085 ID
Currey Ivanov F F - BR 8926.72 4463.36 BR
Larry Pinnocke M M - PH 7273.72 3636.86 PH
Johnny Delepine M M - PK 6468.09 3234.045 PK
Flinn Lewson F F - BR 6636.42 3318.21 BR
Roosevelt Neat M M - UA 4681.84 2340.92 UA
Mohammed Sandwich M M - RU 4572.84 2286.42 RU
Muriel Duckerin M M - CN 5978.01 2989.005 CN
Riordan Whimpenny M M - ID 8079.97 4039.985 ID
Matilde Charman F F - GR 7787.99 3893.995 GR
Olympia Mariolle M M - ID 5441.39 2720.695 ID
Quint Gloy F F - PH 9855.36 4927.68 PH
Sharity Rignall F F - ID 4734.5 2367.25 ID
Maisey Gammet F F - SL 6962.52 3481.26 SL
Dede Glawsop F F - AF 5737.03 2868.515 AF
Hew Dunge M M - CN 6511.88 3255.94 CN
Johanna Hylton M M - CA 5967.83 2983.915 CA
Penny MacPeake M M - FR 3579.41 1789.705 FR
Agnese Savoury M M - BR 3314.17 1657.085 BR
Brnaby Searle F F - PL 5007.21 2503.605 PL
Clayborn Well F F - CN 5631.16 2815.58 CN
Bryant O'Drought M M - CN 4237.8 2118.9 CN
Raddy Curling F F - HT 7991.68 3995.84 HT
Kacey Murcutt M M - CN 3418.97 1709.485 CN
Val Kingsworth M M - TH 7320.41 3660.205 TH
Bendite Boutwell F F - FR 6028.48 3014.24 FR
Blondelle Wrigley F F - ID 8705.8 4352.9 ID
Shantee Finding M M - CN 9974.66 4987.33 CN
Tommy Drennan M M - CN 3396.92 1698.46 CN
Lauri Filipiak F F - ZA 7719.27 3859.635 ZA
Hagan Amorts F F - US 6135.63 3067.815 US
Sabina Bromige F F - BR 9606.05 4803.025 BR
Kevin Wykes M M - ID 8854.99 4427.495 ID
Christy Macci M M - RU 9934.09 4967.045 RU
Dar Boyse M M - CN 7830.07 3915.035 CN
Reuben Liebrecht F F - MG 6596.26 3298.13 MG
Carny Cromarty M M - BA 4639.32 2319.66 BA
Ranee Amott M M - ID 9001.02 4500.51 ID
Xerxes Avramov M M - FI 8359.57 4179.785 FI
Marne Rawdall F F - CN 9649.48 4824.74 CN
Stavros Walkey M M - PT 4195.92 2097.96 PT
Dode Deniskevich M M - NG 8227.51 4113.755 NG
Tremain Mussalli F F - GE 7168.24 3584.12 GE
Holt Jaffra F F - PL 7046.73 3523.365 PL
Karney Karolyi F F - GR 9930.15 4965.075 GR
Erek Willatt F F - CN 6548.12 3274.06 CN
Guss Easman M M - BR 6223.93 3111.965 BR
Ara Drury M M - MX 7028.08 3514.04 MX
Mariska Blaes M M - NG 4219.14 2109.57 NG
Candace Hazeley F F - BD 5989.18 2994.59 BD
Mildrid Chillistone M M - AR 5098.14 2549.07 AR
Barbaraanne Waterman F F - ID 4780.42 2390.21 ID
Markus Forde M M - BF 4390.38 2195.19 BF
Clementia Garman M M - RU 5005.39 2502.695 RU
Karia Moquin F F - UA 3871.9 1935.95 UA
Gabriellia Glasson F F - MX 3185.62 1592.81 MX
Brooks Nettle M M - PL 6331.71 3165.855 PL
Moll Straneo M M - CN 4689.06 2344.53 CN
Audrie Foxton M M - HN 4534.93 2267.465 HN
Izabel Matoshin F F - FM 9546.82 4773.41 FM
Buck Cicccitti F F - ID 9699.73 4849.865 ID
Deina Denkin M M - CN 7901.52 3950.76 CN
Inge Yakovitch F F - RU 5539.88 2769.94 RU
Brantley Losemann F F - FR 9031.27 4515.635 FR
Rex Scogings M M - BR 3720.09 1860.045 BR
Skylar Cometti F F - PH 4880.44 2440.22 PH
Emelina Columbine F F - CN 7175.95 3587.975 CN
Prissie Shankland M M - EG 4559.7 2279.85 EG
Rickert Vellacott M M - ES 9884.7 4942.35 ES
Ernestus Tubridy F F - NZ 4249.05 2124.525 NZ
Bale Naismith F F - PH 5112.07 2556.035 PH
Tabby Magowan F F - PL 3731.52 1865.76 PL
Quincey Ivain F F - PL 8498.57 4249.285 PL
Glory Crumbleholme M M - ID 7100.64 3550.32 ID
Conney Semrad M M - ER 8291.63 4145.815 ER
Loutitia McNish M M - BR 3571.67 1785.835 BR
Thornton Chucks F F - AF 9103.8 4551.9 AF
Skylar Abramovitch M M - PL 3700.28 1850.14 PL
Andi Willmer F F - ID 7342.35 3671.175 ID
Durand Ruck M M - JP 3459.44 1729.72 JP
Freemon Tesdale M M - CN 7508.21 3754.105 CN
Lorilee Sesser M M - ID 6277.32 3138.66 ID
Pepita Bocken F F - PE 3005.06 1502.53 PE
Selena Milstead M M - CN 6848.23 3424.115 CN
Jasun Banghe M M - UA 5699.7 2849.85 UA
Sergeant Perelli F F - RU 6506.65 3253.325 RU
Rex Ucchino M M - CN 6790.27 3395.135 CN
Sigismundo Castellino F F - CN 4506.84 2253.42 CN
Ethelbert Shiers M M - PT 5145.7 2572.85 PT
Tabbitha Grendon F F - US 4737.86 2368.93 US
Anna-maria Bordis M M - PT 4190.15 2095.075 PT
Bernard Custance M M - SA 7695.11 3847.555 SA
Faulkner Paskell F F - PH 3324.27 1662.135 PH
Keelia Pherps F F - ZA 4070.24 2035.12 ZA
Kellina Goodhand F F - CN 9714.47 4857.235 CN
Petronella Janko F F - PT 4503.54 2251.77 PT
Hertha Reynalds M M - PL 9634.29 4817.145 PL
Allyn Watling F F - CN 6206.07 3103.035 CN
Nollie Stoop F F - CN 4971.88 2485.94 CN
Charmaine Esby M M - IR 6661.1 3330.55 IR
Benedick Jina M M - GT 3248.08 1624.04 GT
Dahlia McCard M M - BZ 8552.73 4276.365 BZ
Faber Moulsdall F F - BR 5475.22 2737.61 BR
Trefor Poad F F - GT 8051.16 4025.58 GT
Chris Durram M M - ID 8055.22 4027.61 ID
Bili Dyble F F - TH 8987.75 4493.875 TH
Abeu Watton F F - ZA 7439.41 3719.705 ZA
Vaclav Tadman F F - NO 8203.38 4101.69 NO
Trefor Farge M M - BR 7363.94 3681.97 BR
Ahmad Marin F F - TH 6038.51 3019.255 TH
Sibylla Wittrington F F - PT 9883.86 4941.93 PT
Karita Niezen F F - RS 4812.29 2406.145 RS
Ferdinande Bernakiewicz F F - JP 3119.08 1559.54 JP
Deane Flaverty M M - MG 5082.97 2541.485 MG
Tori Schurcke M M - ID 5108.52 2554.26 ID
Adler Scading M M - MX 7958.74 3979.37 MX
Lauretta Bartosch F F - AR 4691.19 2345.595 AR
Kerri Sommerfeld F F - ID 8231.61 4115.805 ID
Jephthah Coventry F F - JP 5335.06 2667.53 JP
Elaine Doncom M M - MY 3321.63 1660.815 MY
Oralee Butterfill M M - ID 8001.12 4000.56 ID
Charyl Gomer F F - CN 5427.54 2713.77 CN
Pepe Lardge M M - CN 3374.89 1687.445 CN
Verene Brickdale F F - RU 8471.75 4235.875 RU
Felisha Hayhow F F - GR 5571 2785.5 GR
Kelcy Siverns M M - IE 5440.93 2720.465 IE
Andie Gerrietz M M - CN 6618.56 3309.28 CN
Catherina Beeho M M - CN 8210.04 4105.02 CN
Savina Riches M M - CN 9621 4810.5 CN
Maible Borton M M - FR 9788.01 4894.005 FR
Tessa Allwright M M - AR 9957.57 4978.785 AR
Hestia Kybird M M - GR 5619.65 2809.825 GR
Yelena Lackner F F - CN 7029.85 3514.925 CN
Crawford Pettersen M M - UA 9191.18 4595.59 UA
Kass McNirlan M M - MR 8065.4 4032.7 MR
Fernandina Engelmann M M - ID 3802.41 1901.205 ID
Peyter Fisbey F F - CN 7840.25 3920.125 CN
Dillie Pring M M - IL 5512.78 2756.39 IL
Bobine Alves F F - JP 3324.71 1662.355 JP
Adriana Vinick F F - NZ 7096.85 3548.425 NZ
Elmore Radenhurst M M - RU 4305.4 2152.7 RU
Mic Aronowitz F F - ID 6793.98 3396.99 ID
Kathye Rudd M M - CZ 8584.83 4292.415 CZ
Penelope Predohl M M - CN 6249.75 3124.875 CN
Bryn Dron M M - NO 8573.54 4286.77 NO
Libbey Pitrelli M M - RS 6640.27 3320.135 RS
Cissiee Wandless M M - CN 3914.72 1957.36 CN
Currey Rozsa M M - ID 8093.63 4046.815 ID