making a macro input respond to a data type rather than a specific file format

[BillyL14]

Hi

I am trying to create a macro where it can take any numeric data type field. I then would have two summarize tools connected to this, one group by the values and a string and then one that would display total sum of the value,  then I want to union so that the total will show at the bottom of the grouped value.  I want this macro to respond to any input that has numeric fields in it, because I work with many different files and don't want to create the same tool many times.

Is there a way of doing that?

Thanks

[Qiu]

@BillyL14 
Will a field info Tool meet your requirement?

[PhilippK]

Hi @BillyL14 ,

I recommend the DYNAMIC SELECT tool, which allows you to select columns with specific data types, such as numeric columns:

Let me know how you proceed and if you need help with the remaining steps.

Best regards

Phil

[BillyL14]

thanks a lot to both, I am still working on it