SOLVED

# On the bleeding edge with “eta reduced lambda” functions

Brass Contributor

# On the bleeding edge with “eta reduced lambda” functions

Buried in the announcement about New aggregation functions is a reference to “eta reduced lambda functions"; if in the Old Days we had to write:

`` =BYCOL(C3:F6,LAMBDA(x,SUM(x))``

we can now just use:

`` =BYCOL(C3:F6,SUM)``

So far so good. This is really a great improvement in both writing and readability.

Being curious, I wanted to see how it works in a named Lambda function. In the Old Days, I would use this:

``````OldLam = LAMBDA(myrange,
BYCOL(
myrange,
LAMBDA(col, SUM(col))
)
);``````

But trying to use the new eta lambda style, like this:

``````NewLam = LAMBDA(myrange,
BYCOL(
myrange, SUM)
)  ;``````

doesn't work.

I understand this is all beta, etc., but am I doing something wrong or is it a "feature"?

4 Replies

# Re: On the bleeding edge with “eta reduced lambda” functions

Maybe better to post this as a feedback item (Help, Feedback) if you have not already done so?
I tend to write up my problem in Excel cells too, including any screenshots, so I can check the screenshot box to give as much information as I can.
best response confirmed by TheDub (Brass Contributor)
Solution

# Re: On the bleeding edge with “eta reduced lambda” functions

It's working in my Excel:

Version:

# Re: On the bleeding edge with “eta reduced lambda” functions

I guess I wasn't as close to the bleeding edge as I thought! When I posted the question, I was at Version 2401; after seeing your answer, I checked for updates, updated and - with Version 2402 - it now works!

Thanks, Patrick!

# Re: On the bleeding edge with “eta reduced lambda” functions

Glad it worked! I finally received those functions in yesterday's update.
1 best response

Accepted Solutions
best response confirmed by TheDub (Brass Contributor)
Solution

# Re: On the bleeding edge with “eta reduced lambda” functions

It's working in my Excel:

Version: