I am aware of what an array is. I'm not sure if you're being serious or not at
this point.
But from the docs:
----
The functions of this theme perform calculations on a series of values.
The Average, Max, Min, Sum, Sum squares, Std deviation and Variance functions
are applied to fields or arrays:
When applied to fields, they use the current selection of records,
When applied to arrays, they use array elements.
----
Each command has examples. Also from the docs:
----
Example 2
This example gets the highest value in the array:
ARRAY REAL($ArrGrades;0)
QUERY([Exams];[Exams]Exam_Date=!01/07/11!)
SELECTION TO ARRAY([Exams]Exam_Grade;$ArrGrades)
vMax:=Max($ArrGrades)
----
-----Original Message-----
From: 4D_Tech <[email protected]> On Behalf Of Jörg Knebel via
4D_Tech
Sent: Monday, November 1, 2021 12:37 PM
To: 4D Tech Mailing List Technical <[email protected]>
Cc: Jörg Knebel <[email protected]>
Subject: Re: Calculate values of arrays...
> On 02 /11 /2021, at 02:24, Joshua Hunter via 4D_Tech <[email protected]>
> wrote:
>
> You want the docs for 'On a Series'
> https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdoc.4d.com%2F4Dv19R2%2F4D%2F19-R2%2FOn-a-Series.201-5493482.en.html&data=04%7C01%7Cjoshua%40dwdev.com%7C499e1bb59b194a3744b108d99d6ef72d%7C9aa9e914bc4247ea8bd05d0497a4c311%7C0%7C0%7C637713922193566270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=SBCBtITrNcuwCqMKw1GyOAUAX0%2BevmaMNdWTpf%2FQWk0%3D&reserved=0
>
> <https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdoc.4d.com%2F4Dv19R2%2F4D%2F19-R2%2FOn-a-Series.201-5493482.en.html&data=04%7C01%7Cjoshua%40dwdev.com%7C499e1bb59b194a3744b108d99d6ef72d%7C9aa9e914bc4247ea8bd05d0497a4c311%7C0%7C0%7C637713922193566270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=SBCBtITrNcuwCqMKw1GyOAUAX0%2BevmaMNdWTpf%2FQWk0%3D&reserved=0>
And this works on an ARRAY how?
You do know what an ARRAY is?
**********************************************************************
4D Internet Users Group (4D iNUG)
New Forum:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdiscuss.4d.com%2F&data=04%7C01%7Cjoshua%40dwdev.com%7C499e1bb59b194a3744b108d99d6ef72d%7C9aa9e914bc4247ea8bd05d0497a4c311%7C0%7C0%7C637713922193566270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=9660Yd73u%2F%2Fxrv7ekiq5GsisKQ7a7nEPOYhJLGL4nu4%3D&reserved=0
Archive:
https://nam10.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.4d.com%2Farchives.html&data=04%7C01%7Cjoshua%40dwdev.com%7C499e1bb59b194a3744b108d99d6ef72d%7C9aa9e914bc4247ea8bd05d0497a4c311%7C0%7C0%7C637713922193566270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=nR5EhMyJOcfdGAdGJB8F3RDASGyKO2NCkIiPyzwQdDQ%3D&reserved=0
Options:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.4d.com%2Fmailman%2Foptions%2F4d_tech&data=04%7C01%7Cjoshua%40dwdev.com%7C499e1bb59b194a3744b108d99d6ef72d%7C9aa9e914bc4247ea8bd05d0497a4c311%7C0%7C0%7C637713922193566270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=26fvTDknRLmrjhTGxM6HCR8QDUjUQLcnM9k00VezsVY%3D&reserved=0
Unsub: mailto:[email protected]
**********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
