Skip to Main Content
Categories Expression Engine
Created by Guest
Created on Mar 6, 2026

Introduce 'LET' Function to Expression Engine

How: Add a LET function (from Excel) to the Expression Engine that allows us to define a variable (a shortcut) for a calculation and then reuse that variable later in the same formula. The syntax should look like: =LET(VariableName, Calculation, Result)

Why: Right now, if I need to find a specific linked item and check its price across four different tiers, I have to copy and paste the exact same "search" logic four or five times in one formula. This makes the formulas extremely long, very hard to read, and risky to update because if I change a value in one spot, I have to remember to change it in five others.

For Who: Anyone who builds or maintains expressions in Inriver; PIM Developers, Administrators, and Solution Architects.

Impact: It will make formulas much shorter and easier to maintain. More importantly, it will improve system performance. Instead of Inriver having to run the same complex search five times for one field, it would run it once and remember the result. This means faster Save times in Enrich and faster bulk rebuilds.

Additional context: This is a standard feature in modern Excel that has solved the "mega-formula" problem. In Inriver, where we do a lot of FILTER(LINKEDENTITIES(...)) logic, this would be a massive quality-of-life improvement and would prevent many "copy-paste" errors during implementation.


Please, add your suggestion and feedback above to add to the insights used by Product team when deciding priorities and direction of the Inriver PIM.

  • Attach files