Forum Discussion
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"?
- Patrick2788Silver Contributor
- TheDubIron 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!- Patrick2788Silver ContributorGlad it worked! I finally received those functions in yesterday's update.
- JKPieterseSilver ContributorMaybe 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.