Formula Query (Size) - Question

Question

I have created the following Number Formula query in Table A:

My goal is to calculate the total records in 5 non-related Tables. The [Table Alais] field represents the Table Alais for the 5 different tables -- and the [AlaisTableFieldID] is my query field. This formula is not working.....any advice is appreciated.

Size(GetRecords("{"&[AlaisTableFieldID]&".EX.'"&[Record ID#]&"'}","&[Table Alais]&"))

donlarson · Answer

Any chance your use of "Alais" instead of "Alias" is breaking your formula?&nbsp; &nbsp;Did you define the variables differently further up in the field?

markshnier__you · Answer

Can you explain again what you are trying to do here?&nbsp; Are you saying you just want the record count in a table?Size(GetRecords("{3.GT.0}", [Table Alais]))

Forum Discussion

Formula Query (Size) - Question