Forum Discussion

TheDub's avatar
TheDub
Iron Contributor
Jan 08, 2024

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

    • TheDub's avatar
      TheDub
      Iron Contributor

      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!

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Glad it worked! I finally received those functions in yesterday's update.
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    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.

Share

Resources