Jan 08 2024 06:18 AM - edited Jan 08 2024 06:20 AM
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"?
Jan 08 2024 06:35 AM
Jan 09 2024 02:53 PM
SolutionJan 10 2024 04:14 AM - edited Jan 10 2024 04:15 AM
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!
Jan 10 2024 04:34 AM
Jan 09 2024 02:53 PM
Solution