I've used this formula to create a sequential number based on the count of records for each customer; however, it returns the value of zero instead of summing the records as stated above. For example, I currently have two records for our NE division in 2025, but the result is "NE-0-2025" instead of "NE-1-2025" and "NE-2-2025".
Is there an error in the formula below?
var number estnumber =
Size(
GetRecords(
"{121.EX.'"&[Region Short Name]&"'}AND{57.CT'"&Year([Documents Received Date])&"'}"&If(not IsNull([Record ID#]),"AND{3.LTE'"&[Record ID#]&"'}")
));
[Region Short Name]&"-"&$estnumber&"-"&Right(ToText(Year([Documents Received Date])),4
)
