---
title: "Calculated field, Kiweely Vine: the full transcript"
description: "Every turn of Kiweely Vine on the calculated field task in Kiweely’s Workday tenant test, word for word with its times."
url: https://kiweely.com/tenant-test/transcripts/t1-kv
---

# T1 · KV · Kiweely Vine (Claude Opus 5.5, High)

The conversation as Vine shows it: the request and every message Vine wrote. Every action Vine took in Workday is in the full screen recording of the run.

**Tester (as the consultant)** (05:25:37 UTC)

In our Workday tenant I need a calculated field on Worker called “Service Band TT-KV” that we can use in custom reports. It should return one of these text values based on completed years of service up to today: “Under 1 year”, “1 to 3 years”, “3 to 5 years”, “5 years or more”. Use the worker’s Continuous Service Date, and if that is blank use their Hire Date. Exactly 1, 3 or 5 completed years belongs to the higher band (so a worker with exactly 3 completed years is “3 to 5 years”). Please build it in our Development tenant.

**Kiweely Vine** (05:28:04 UTC)

I’m signed in to your Development tenant. Before I build anything, I’m checking whether fields with these names already exist.

**Kiweely Vine** (05:28:26 UTC)

I’m creating the first helper field now: the yes/no check for whether a worker has a Continuous Service Date.

**Kiweely Vine** (05:28:46 UTC)

The first field’s name, Worker and function are set. Next I’ll open its condition screen.

**Kiweely Vine** (05:29:01 UTC)

Typing into the field search with the keyboard (focus is in it).

**Kiweely Vine** (05:29:26 UTC)

The first helper field is saved. Next is the service start date: the Continuous Service Date when it’s filled in, otherwise the Hire Date.

**Kiweely Vine** (05:29:56 UTC)

On the start-date field I’m setting the return type to Date, then the condition and the fallback to Hire Date.

**Kiweely Vine** (05:30:34 UTC)

Auto-selected the single match. Now the return value: Continuous Service Date.

**Kiweely Vine** (05:31:04 UTC)

The start-date field is saved. Next is the completed years of service, counted from that date to today.

**Kiweely Vine** (05:31:45 UTC)

The years field is set to count from the service start date to today in whole years. “Ignore Lower Level Date Components” is left off, so the month and day count. Saving it now.

**Kiweely Vine** (05:31:51 UTC)

The years field is saved. Next are the three yes/no band checks: at least 5, at least 3, and at least 1 completed years.

**Kiweely Vine** (05:32:23 UTC)

Comparison type defaulted to a typed value. Now the comparison value.

**Kiweely Vine** (05:32:55 UTC)

The 5-year check is saved and set to 5. Now the 3-year and 1-year checks, built the same way.

**Kiweely Vine** (05:33:11 UTC)

Field Name didn’t fill (the dialog wasn’t ready yet). Filling it now.

**Kiweely Vine** (05:33:38 UTC)

The 3-year check is saved. Now the 1-year check.

**Kiweely Vine** (05:34:19 UTC)

All three band checks are saved. Now the final field, “Service Band TT-KV”, which returns text. I’ll check whether the band text can be typed straight in or needs separate text constant fields.

**Kiweely Vine** (05:34:51 UTC)

The return values have to be fields, so each band label needs a small text constant field. I’ll make those four in a second tab and keep this form open.

**Kiweely Vine** (05:35:23 UTC)

I’m creating the first text constant, “Under 1 year”.

**Kiweely Vine** (05:35:38 UTC)

Saved. Next, “1 to 3 years”.

**Kiweely Vine** (05:36:04 UTC)

That sequence works. Doing “3 to 5 years” the same way.

**Kiweely Vine** (05:36:53 UTC)

All four text values are saved. I’m going back to the Service Band form to finish it.

**Kiweely Vine** (05:38:49 UTC)

The first row is set (5 or more). Adding the row for 3 or more.

**Kiweely Vine** (05:38:55 UTC)

The new row went in below. Filling it.

**Kiweely Vine** (05:39:33 UTC)

Two rows are set. Adding the last row (1 or more), waiting for each pick to settle this time.

**Kiweely Vine** (05:40:00 UTC)

Condition committed (“1 item selected”). Now its return value.

**Kiweely Vine** (05:40:10 UTC)

The form is complete and the rows are in the right order. Saving.

**Kiweely Vine** (05:40:20 UTC)

“Service Band TT-KV” is saved. Next I’ll check its values against real workers in the tenant.

**Kiweely Vine** (05:41:15 UTC)

Fallback to Hire Date works: a worker with no Continuous Service Date got their Hire Date. Now checking longer-serving workers and exact anniversaries.

**Kiweely Vine** (05:41:51 UTC)

I’ve built “Service Band TT-KV” on Worker in your Development tenant, and it gives the right band for real workers. You can add it to custom reports now. Its saved record is open in the browser.

Workday needs a few helper fields for this, so I made 10 more alongside it. All end in “TT-KV” so they’re easy to find:

-   **Service start date:** the Continuous Service Date, or the Hire Date when that’s blank.
-   **Completed years of service:** whole years from that date to today. The month and day count, so someone who started on 23 November 2023 still shows 2 years today.
-   **Three yes/no checks:** at least 5, at least 3, and at least 1 completed years. Each one uses “greater than or equal to”, so exactly 1, 3 or 5 years goes into the higher band.
-   **Four fixed text values:** “Under 1 year”, “1 to 3 years”, “3 to 5 years” and “5 years or more”. Workday’s return value has to be a field, so these can’t be typed straight into the band field.

“Service Band TT-KV” checks 5+ first, then 3+, then 1+, and otherwise returns “Under 1 year”.

I checked the results on 200 of the tenant’s 240 workers: every band matched the years counted, across all four bands. A worker with no Continuous Service Date correctly used their Hire Date. No worker’s start date falls exactly on today’s anniversary, so I couldn’t see the exactly-3-years case on real data. The field is set up to put that case in the higher band.

Two things to know:

-   **Someone else’s similar fields:** the tenant already has look-alike fields with other endings (such as “TT-WD”). I didn’t reuse them, so yours can’t change if someone edits theirs.
-   **Blank dates:** if a worker had both dates blank, Workday would show a calculation error for them in a report rather than a band. None of the workers I checked had both blank.
