SOLVED

On the bleeding edge with “eta reduced lambda” functions

Brass Contributor

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
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

@TheDub 

It's working in my Excel:

Patrick2788_0-1704840737501.png

Version:

Patrick2788_1-1704840805404.png

 

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!

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

@TheDub 

It's working in my Excel:

Patrick2788_0-1704840737501.png

Version:

Patrick2788_1-1704840805404.png

 

View solution in original post