A Workday calculated field returns blank when its function finds nothing to return: no related instance, a condition that excludes the row, a value outside every range, or an empty source date. It also returns blank when the report’s data source cannot reach the field’s business object, or when the person running the report lacks access to a field it reads. Build a one-row test report on a known instance first; it tells you which of these you have.
If the field returns a value and the value is wrong, that is a different problem with its own method; this page covers blank and zero.
How do I find out why a calculated field is blank?
- Pick one row that is blank and one that is not. Build a test report on the same data source as the real one and filter it to the blank row.
- Add the calculated field, then add each field it reads in its own column, including fields reached through a related business object. Workday’s View Calculated Field report gives you the definition.
- Read from left to right. The first source column that is empty, or holds a value you did not expect, is where the chain breaks.
- If every source column holds the value you expect and the calculated field is still blank, compare the business object (next section), then run the report as someone with broader access.
Match the symptom to the likely cause before opening the definition:
| Symptom | Likely cause | Check |
|---|---|---|
| SymptomBlank on every row | Likely causeField’s business object is not related to the report’s data source | CheckCompare the field’s Business Object with the report’s data source |
| SymptomBlank on some rows only | Likely causeA related instance is missing, or a condition excludes the row | CheckOne-row test report on a blank row |
| SymptomZero where a number is expected | Likely causeReturn Zero on Error is hiding an error | CheckClear it in a nonproduction tenant and read the error |
| SymptomThe Default Value shows | Likely causeAn earlier or no Evaluate Expression condition is true | CheckRead every condition row in order |
| SymptomBlank or zero for one user only | Likely causeThat user lacks access to a field the calculation reads | CheckCompare field-level access, including related objects |
| SymptomWorks in one tenant, blank in another | Likely causeSame name, different definition, path or security | CheckCompare View Calculated Field in both tenants |
Does the calculated field’s business object match the report?
A calculated field belongs to one business object, and that choice decides where you can use it and which fields it can read (Create Calculated Fields). A report returns a value for the field only when the data source’s primary business object is that object, or the field is reached through a related object. A field built on Worker is blank, or missing from the picker, on a report whose source is Position.
Missing from the picker is a separate failure from blank, with its own causes: the field’s business object, report type, Optimized for Performance and field security. Report-specific calculated fields are also unavailable on simple reports (Setup considerations: calculated fields).
Which functions return blank, and exactly when?
Workday’s documentation states the empty case for most functions. This table lists each, the behaviour, and the setting that changes it.
| Function | Returns blank, zero or an error when | Setting that changes it |
|---|---|---|
| FunctionExtract Single Instance | Returns blank, zero or an error whenNo related instance satisfies the Condition: it returns zero or one instance | Setting that changes itCondition, Sort Field, Instance to be Returned |
| FunctionLookup Related Value | Returns blank, zero or an error whenThe lookup field points at nothing (it needs a one-to-one relationship), or at an Extract Single Instance that returned zero instances | Setting that changes itFix the source field or add a fallback |
| FunctionExtract Multi-Instance | Returns blank, zero or an error whenNo instance matches: it returns an empty value. Intersection returns only instances common to both source fields | Setting that changes itOperation Type, Condition |
| FunctionEvaluate Expression | Returns blank, zero or an error whenNo condition is true: it returns the Default Value | Setting that changes itDefault Value, row order |
| FunctionLookup Range Band | Returns blank, zero or an error whenThe value falls in no configured range: it returns a blank instance (Workday Education) | Setting that changes itAdd a band that covers the value |
| FunctionDate Difference | Returns blank, zero or an error whenThe Start Date Field or End Date Field is blank | Setting that changes itReturn Zero on Error: shows 0 instead of an error |
| FunctionIncrement or Decrement Date | Returns blank, zero or an error whenThe date field is blank | Setting that changes itReturn Blank Date on Error: shows blank instead of an error |
| FunctionConvert Currency | Returns blank, zero or an error whenThe As Of Date Field is blank, or no data exists for the amount, target currency and rate type: zero or an error | Setting that changes itReturn Zero on Error (covers a blank As Of Date) |
| FunctionConvert Text to Number | Returns blank, zero or an error whenThe text is not numeric | Setting that changes itReturn Zero on Error: shows 0 instead of an error |
| FunctionArithmetic Calculation | Returns blank, zero or an error whenDivision by zero | Setting that changes itReturn Zero on Error: shows 0 instead of an error |
| FunctionLookup Translated Value | Returns blank, zero or an error whenThe text has no translation in the requested language | Setting that changes itReturn Base Language if Not Found: clear it to get blank instead of the base language |
| FunctionSubstring Text | Returns blank, zero or an error whenWith Between two Delimiters, the end delimiter is missing and Exclude Results without End Delimiters is selected | Setting that changes itThat check box |
Three points that catch people:
- Return Zero on Error never produces a blank. It produces 0, which looks like a real answer. Arithmetic Calculation applies it to division by zero; do not assume it also covers a missing operand.
- Date Difference gives the classic case: a worker hired on 01/01/2020 who is still active has no Termination Date, so a field with Termination Date as its End Date Field has a blank to work with. Without Return Zero on Error the result is an error; with it, 0 (Date Difference).
- Lookup Value as of Date ignores its Effective Date if the source field’s business object does not support effective dating, and returns the current value (Lookup Value as of Date). That is a wrong-looking date, not a blank.
How do I extract a single instance in Workday?
Extract Single Instance (ESI) turns a multi-instance field, such as a worker’s benefit elections, into one instance. It is the function most often behind a blank, because it returns zero instances whenever nothing meets its condition. The settings in the Create Calculated Field task (Extract Single Instance):
| Setting | What it does |
|---|---|
| SettingSource Field | What it doesA multi-instance field with a one-to-many relationship to the field’s business object |
| SettingCondition | What it doesA true/false condition on the related object; a global field such as Is True accepts every instance (Workday Education) |
| SettingSort Field | What it doesRequired; decides which instance wins when several qualify. A global field such as Any Field fits when the condition leaves one instance (Workday Education) |
| SettingSort Direction | What it doesStart from the end that reaches your target: most recent first means descending on a date |
| SettingInstance to be Returned | What it doesFirst occurrence, last occurrence or a specific occurrence |
An ESI returns an instance, not a value. To show the plan name or a date from it, build a Lookup Related Value field on the same object with the ESI as the Lookup Field. Full walkthrough: Extract Single Instance.
Worked example: a plan name that is blank for one worker
An illustrative chain on the Worker object, with made-up data. “Current Medical Election” is an ESI over Benefit Elections with the condition Coverage Type is Medical and Active. “Medical Plan Name” is a Lookup Related Value that returns Benefit Plan from it.
| Worker | Elections held | Current Medical Election | Medical Plan Name |
|---|---|---|---|
| WorkerA | Elections heldMedical, Dental | Current Medical ElectionMedical election | Medical Plan NameStandard Plan |
| WorkerB | Elections heldMedical (ended), Dental | Current Medical Electionnone | Medical Plan Nameblank |
| WorkerC | Elections heldDental only | Current Medical Electionnone | Medical Plan Nameblank |
Workers B and C show blank for different reasons, and the report cannot tell them apart. The one-row test report on B shows it: add the ESI beside the plan name, then the election’s coverage type and end date. The condition asks for an active medical election, B’s has ended, and the ESI returns zero instances. The Lookup Related Value has nothing to read.
Two fixes, depending on the intent. If a blank is correct for B and C, leave the chain and label it: wrap the plan name in an Evaluate Expression whose default is the text “No medical coverage”. If B should still show their last plan, loosen the ESI condition to Coverage Type is Medical, sort by end date, and return the last occurrence.
Does the Dev tenant show the same pattern?
A real check, read-only through WQL on 16 November 2026. A calculated field with no value is left out of a row’s data entirely. Query:
SELECT worker, hireDate, cf_RPTLRVWorkerSecondToLastPromotionDate, cf_RPTEEWorkerSecondToLastPromotionDateOrHireDate FROM allWorkers LIMIT 6For the first worker, hired 2015-01-01, the response held hireDate and cf_RPTEEWorkerSecondToLastPromotionDateOrHireDate (“2015-01-01”). It held no cf_RPTLRVWorkerSecondToLastPromotionDate at all. The same pattern held for all six rows. The pair shows the difference between a field with a fallback and one without: for these demo workers the field named “or Hire Date” returns a date, and the plain second-to-last-promotion field returns nothing. WQL does not show the definitions, so the cause is inferred from the names, not read from the field.
Can effective dates and prompts blank a field?
Lookup Value as of Date reads a field as of an Effective Date and an Entry Date, and a date without a time such as Today is read as 00:00:00 (Lookup Value as of Date). If the field is prompted at run time, check what the person running the report supplied. A blank or default prompt value changes the result without changing the definition. On a custom object, Lookup Value as of Date always returns the latest value, because Workday stores only the current value there.
Why does it work for me and not for them?
A calculated field’s security follows the fields it is built from. You need access to every field in the calculation. Without it, Workday shows zero for currency and numeric fields and blank for every other type (Calculated fields security). Workday’s own example: an Extended Amount field that multiplies Hours by Rate needs access to both.
Compare each person’s access to the underlying fields, including fields on related objects. Check report sharing separately: a person can run a shared report and still lack one of the fields.
Does a text result cause blank in a date or number column?
Format Date returns text, not a date, so a downstream field expecting a date can show blank or sort wrongly. Format Mask letters are case-sensitive (Format Date). Convert Text to Number reads the display ID when the source is a single-instance field, and its Decimal Separator decides how 123.4 reads. With “Based on user’s locale”, that text is computed as 1234 in regions that use commas as decimal separators (Convert Text to Number).
What if it breaks only after a tenant copy?
Compare View Calculated Field in both tenants, not just the names. Definitions, related-object paths and security can differ, and a value the field references may not exist in the second tenant. Copying Workday configuration between tenants covers carrying the exact condition grid across. If the blank field drives a business process step, see why a condition rule is not working.
Kiweely Vine is a desktop AI agent for Workday that can answer Workday questions and read a client’s tenant with consent, so the one-row test above can be run against the tenant for you.
Frequently asked questions
Why is my calculated field blank for some workers and not others?
Because the function found nothing for those workers: no related instance, a condition that excluded them, a value outside every range, or a blank source date. Test one affected worker in a one-row report with each source field beside the calculated field.
Does Extract Single Instance return an error when nothing matches?
No. It returns zero instances or one, so a condition that nothing satisfies leaves the field without a value, and any Lookup Related Value built on it has nothing to return.
What does Return Zero on Error actually change?
It swaps an error for 0. In Arithmetic Calculation that applies to division by zero, in Convert Text to Number to non-numeric text, in Date Difference to a blank start or end date. The zero can look like a real answer.
Why is a calculated field blank for one user but fine for me?
Workday returns zero for numeric and currency calculated fields, and blank for every other type, when the viewer lacks authorization to a field the calculation reads. Compare both users' access to each underlying field.
How do I extract a single instance in Workday?
Create a calculated field with the Extract Single Instance function: choose the multi-instance Source Field, a Condition, a required Sort Field and Sort Direction, and which occurrence to return. Pair it with Lookup Related Value to pull one value from the instance.
Sources checked
- Setup considerations: calculated fields
- Calculated fields security
- Lookup Related Value
- Extract Single Instance
- Extract Multi-Instance
- Evaluate Expression
- Date Difference
- Increment or Decrement Date
- Convert Currency
- Convert Text to Number
- Arithmetic Calculation
- Lookup Value as of Date
- Lookup Translated Value
- Substring Text
- Workday Education: Calculated Fields (Workday Reporting course)