Skip to main content

Varicent ELT Assistant

Release notes

3.99.0 - Week of August 4, 2026

It's even better now

We took the time to revamp some of the things you already love.

Truncate numeric values in the Formula tool

The Formula tool now supports the truncate(value, num_digits) function in Varicent ELT and Designer. You can use this function to truncate numeric values toward zero at a specified number of decimal places, without creating complex formula workarounds.

  • Use a positive num_digits value to retain decimal places.

  • Use 0 to remove all decimal places.

  • Use a negative num_digits value to truncate digits to the left of the decimal point.

For example:

  • truncate(3.789, 2) returns 3.78.

  • truncate(-3.789, 2) returns -3.78.

  • truncate(3.9, 0) returns 3.

  • truncate(386.9, -1) returns 380.

To learn more about truncating numeric values, read the Formula tool documentation.

Custom host suffixes for Workday connections

We've added an optional host suffix setting for Workday import and export connections. You can now specify the suffix required by your service endpoint, such as myworkday.com, instead of relying on a predefined domain. 

This flexibility helps you connect when your service uses a newer or alternative endpoint format. Existing connections remain compatible and continue to work without configuration changes. If a connection requires a different suffix, a message guides you to update the setting. Learn more about Workday import and Workday export.

Control pipe role access at the folder level

You can now configure pipe access at the individual folder and subfolder level within the Roles permissions. Previously, pipe access was controlled only at the module level. With this update, you can enable or disable View, Edit, and Delete permissions for folders and subfolders, giving organizations more granular control over who can access sensitive pipelines. 

Key behaviors in the role permissions for pipe folders:

  • Default inheritance: Subfolders inherit permissions from their parent folder unless overridden.

  • Partial access: If a user has access to a subfolder but not to its parent, the parent folder remains visible as a container, but its pipes are inaccessible.

  • Dynamic updates: Folders that are renamed, moved, or deleted are reflected automatically on the Roles page.

  • Moving pipes: Moving a pipe between folders requires View, Edit, and Delete permissions on both the source and destination folders.

  • Uncategorized pipes: Pipes not assigned to a folder appear under Pipes and retain full View, Edit, and Delete permissions.

Learn more about roles in pipe folders.

We crushed some bugs!

And we're so happy that we did...

Issue

Bug number

Fixed a concurrency issue that could cause multiple Incentives calculations referencing the same Varicent ELT pipe to abort when they ran at the same time.

233466

Fixed an issue where changes to export notification settings appeared to save but were not retained after the page was refreshed.

234120

Fixed an intermittent issue where stale checkpoint data for a previous run could cause an unexpected export error and fail a scheduler step.

233621