Software Technology Tips

How to retrieve last value in an array type number field and calculate any number functions on this field?

Lets say my field is "TEST" number type and repetition is 6 in table Dashboard and I have entered values to that field as 1,3,2,5,8,4

Then calculation Last (Dashboard::TEST) will return value 4

Max (Dashboard::TEST ) will return 8

Min ( Dashboard::TEST ) will return 1

Sum (Dashboard::TEST) will return 23

Note: If the TEST field is text type and having values as ABC,XYZ,OPQ,A,B,RST then Last (Dashboard::TEST) will return value RST

Related Tags:
Filemaker

Author: Elishree Dey

Filemaker